Registered aircraft · 54,015

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

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') ORDER BY n_number

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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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.

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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N770HTailwind Aviation LLC · Huntingburg, INBuilt 1966 · S/N 18257818 N770NAOrganization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1975 · S/N 15077280 N770SPHa Emily J · Fort Worth, TXBuilt 1970 · S/N 15071805 N7710TMorton David W · Brady, TXBuilt 1960 · S/N 47310 N7710XGraves Robert D · Elberton, GABuilt 1960 · S/N 17248210 N7711AMckay Donald A · Soldotna, AKBuilt 1956 · S/N 32608 N7711DCaldwell Joel A · Kenai, AKBuilt 1976 · S/N U206-03170 N7711FMcclain Eugene L · Maryville, TNBuilt 1966 · S/N 15063811 N7711GTrans Meridian LLC · Fort Myers Beach, FLFirst renewal noticeS/N P21000072 N7711LClick Justin T · Hobart, INBuilt 1969 · S/N 185-1521 N7711TBaker Eddy · Waynesville, ILBuilt 1960 · S/N 47311 N7711UHaneline Douglas A II · Statesville, NCFirst renewal noticeS/N 17251711 N7712AMizer James D · Hailey, IDFirst renewal noticeBuilt 1956 · S/N 32609 N7712UGolding James M · Diamond Springs, CABuilt 1964 · S/N 17251712 N7713GDavenport Jimmy J · Hayesville, NCS/N 17259413 N7713THatton Daniel R · Portland, ORS/N 47313 N7713UDavisson Paul V · Jupiter, FLBuilt 1964 · S/N 17251713 N7714ALawyers Real Estate Services LLC · Hondo, NMBuilt 1956 · S/N 32611 N7714FRegistration Pending · Oxford, MIRegistration pendingS/N 15063814 N7714GGlynco Manning Aviation Inc · Brunswick, GABuilt 1970 · S/N 17259414 N7714UKimbrell Quentin · Cape Girardeau, MOS/N 17251714 N7714XLenhardt Edward J · Green Lane, PABuilt 1961 · S/N 17248214 N7715AWallace Wayne P · Graham, WABuilt 1956 · S/N 32612 N7715GAirborne LLC · Wilmington, DEBuilt 1970 · S/N 17259415 N7715KDutch Air LLC · Kalispell, MTBuilt 1976 · S/N 18052708 N7715UFenton Dale R · New Bern, NCBuilt 1964 · S/N 17251715 N7716GFirst Eclipse Ltd · Richmond, VABuilt 1971 · S/N 17259416 N7716UOpportune Entity LLC · Sanger, TXBuilt 1964 · S/N 17251716 N77177Nazario Caleb R · Orlando, FLBuilt 1977 · S/N 177RG1118 N7717AMcclelland Jacob D · Fairfield, CABuilt 1964 · S/N 15060886 N7717GJohnson Eric C · Turtle Lake, NDBuilt 1970 · S/N 17259417 N7717TGully Samuel Lee · Noxapater, MSBuilt 1960 · S/N 47317 N7717UGreen Castle Aero Club Ltd · Oxford, IABuilt 1964 · S/N 17251717 N77182Magro Daniel L Sr · Piperton, TNS/N 182-65921 N77185Carter Danny · Baxley, GABuilt 1973 · S/N 18261744 N7718FAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1966 · S/N 15063818 N7718URenninger Dustin L · Mc Veytown, PAS/N 17251718 N7719TRushton George Emery · Clinton, MIS/N 47319 N771DCTlh Enterprises Inc · Corsicana, TXS/N 18504205 N771EEBtr Inc · Chula Vista, CAS/N 18254542 N771KKnutson Aviation Inc · Cedar Hill, TXBuilt 1977 · S/N 18052899 N771KCAkin John · Highland, CABuilt 1975 · S/N 18264033 N771PMaxq Composites LLC · Oxford, MEBuilt 1969 · S/N 337-1165 N771SMGilbreath Tony C DBA · Olustee, OKBuilt 1967 · S/N 337-0614 N771XRanney Dorothy Gayle · Cordova, AKBuilt 1967 · S/N 185-1336 N77206Venture Alaska LLC · Homer, AKBuilt 1977 · S/N U20603771 N7720AKrueger Eric J · Olivehurst, CABuilt 1956 · S/N 32617 N7720GZulu Jets LLC · Boerne, TXBuilt 1970 · S/N 17259420 N7720XJeter Thomas L · South Padre Island, TXBuilt 1960 · S/N 17248220 N7721AAngel Steven · Fairbanks, AKBuilt 1956 · S/N 32618

Back to AD 87-20-03 R2