OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,920

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N7494PM And P Aviation Inc · Albia, IABuilt 1961 · S/N 24-2689N7494YRay James O III · Mc Rae, GABuilt 1964 · S/N 30-555N7495PSale Reported · Fort Lauderdale, FLSale reported, pending cancellationBuilt 1961 · S/N 24-2690N7496PS & S Air Inc · Wilmington, DEBuilt 1961 · S/N 24-2691N7497KMorris John A · Phoenix, AZS/N 20-411N7497PLift Aircraft LLC · Carmel, INBuilt 1961 · S/N 24-2692N7498PKarnegis Frank J · Senoia, GABuilt 1961 · S/N 24-2693N7499KBarnes Darin L · Wasilla, AKS/N 20-413N7499PTri-C Farms · Tompkinsville, KYBuilt 1961 · S/N 24-2696N74ABAerial Digital Images LLC · Huntington Beach, CABuilt 1959 · S/N 23-1656N74BBHy Aviation LLC · San Juan, PRBuilt 1971 · S/N 27-4750N74BNBig Bend Community College Foundation · Moses La, WABuilt 1969 · S/N 30-1806N74LRRemy Lange · East Greenville, PAS/N 27-7405363N74PLAncient Pelican Aviation LLC · Vero Beach, FLS/N 27-7405272N74YCButzer Brian K · Boca Raton, FLBuilt 1969 · S/N 30-1847N7500DRiggin Flight Service Inc · Madison, SDBuilt 1957 · S/N 22-5227N7500PBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 24-2699N7502DFlight Lead LLC · Casper, WYS/N 22-5229N7503PHouseth Timothy C · Hastings, MNBuilt 1961 · S/N 24-2704N7503YCunneen Sean M · Vista, CABuilt 1964 · S/N 30-565N7505DCronan Joseph M · Santa Maria, CABuilt 1957 · S/N 22-5232N7506ZStuder Al C · Shelby, MIBuilt 1965 · S/N 25-3538N7509DPiggott Philip W · Peru, INBuilt 1957 · S/N 22-5236N7509PSuperbird Aviation LLC · Atlantic, IABuilt 1961 · S/N 24-2710N750AURunamuck LLC · New Orleans, LABuilt 2025 · S/N 4496619N750HKRegistration Pending · Lutz, FLRegistration pendingS/N 30-947N750RTBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2021 · S/N 4496529N7510PMavco Corp · Lewes, DEBuilt 1961 · S/N 24-2711N7514DAdams Stephen K · Lopez Island, WABuilt 1957 · S/N 22-5242N7515PRyan John David · Fort Rucker, ALBuilt 1961 · S/N 24-2716N7515YJohnson Max L Jr · Greenville, SCBuilt 1964 · S/N 30-579N7516DRoot Eric J · Lakewood, COBuilt 1957 · S/N 22-5244N7516PHawkinson Dustin R · Glendale, AZBuilt 1961 · S/N 24-2717N7516ZTruckee Tahoe Soaring Assoc · Truckee, CABuilt 1965 · S/N 25-3556N7517DSoltura Ariel · Chappell Hill, TXBuilt 1957 · S/N 22-5245N7517PRitzheimer Eric R · Glendale, AZS/N 24-2718N7518PLasswell Joel E · Arcola, ILS/N 24-2719N7519YDunshee Kevin G · La Luz, NMBuilt 1964 · S/N 30-584N751WWVicentin De Oliveira Ricardo · Winter Garden, FLBuilt 1967 · S/N 30-1449N7520DPerron John J · Lodi, WIS/N 22-5248N7520PRomo Victor Gerardo · Menifee, CAS/N 24-2722N7520YWendelburg Kevin R · Moreland, GABuilt 1964 · S/N 30-585N7521DLaabs Francis C · Ames, IABuilt 1957 · S/N 22-5249N7522DCorbett Grant J · Nampa, IDBuilt 1957 · S/N 22-5250N7522PXair LLC · El Cajon, CABuilt 1961 · S/N 24-2724N7523DRoss David R · Wakeman, OHBuilt 1957 · S/N 22-5251N7523YBarry Patric · Laguna Hills, CABuilt 1964 · S/N 30-588N7523ZAmerican Ag Aviation LLC · Belden, MSBuilt 1965 · S/N 25-3564N7524DGreene Robert M · Limestone, TNBuilt 1957 · S/N 22-5252N7525DRedhanded LLC · Dover, DEBuilt 1957 · S/N 22-5255
Back to AD 85-02-05 R1