Skip to content

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.

N60SSDhone Shridhar · Livermore, CABuilt 1968 · S/N 17257479 N60STStefenelli Aviation N-Tr Inc Trustee · AtterseeS/N P3370314 N60SXDitzler Enterprises Inc · Grinnell, IAS/N 15285148 N60VAFlying Rhino Aviation Ltd · Alliance, NEBuilt 1976 · S/N 18503141 N60WRadisch Herbert R Jr · San Diego, CABuilt 1949 · S/N 7385 N60XSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18503908 N60XMAircraft Partner N60xm Dst · Wilmington, DES/N 18050968 N60YAnthem Commercial Air Services Inc · Saint Augustine, FLBuilt 1976 · S/N 33701735 N60YGLindstrom Dave C · Marinette, WIBuilt 1974 · S/N 17263953 N61001Monroe Perry M · Woodinville, WABuilt 1969 · S/N 15070724 N61009Jansky Michael J · Hallettsville, TXBuilt 1969 · S/N 15070730 N6100BParas Mark J · Camas, WAS/N 21058068 N6100FTri Rotor Spray & Chemical · Ulysses, KSBuilt 1968 · S/N 21059000 N6100GEvent Tech Services LLC · Quarryville, PABuilt 1969 · S/N 15071600 N6100YRamsay Allan Trustee · Modesto, CABuilt 1981 · S/N 21064250 N61010Hall Scotty · Cheraw, SCBuilt 1969 · S/N 15070731 N61019Goodwin William J · Charlotte C H, VAS/N 15070738 N6101BRegistered aircraftS/N 34101 N6101EScherer Dean W · Saint Joseph, MNS/N 46201 N61020Houk Sean R · Lyons, OHBuilt 1969 · S/N 15070739 N61025Registered aircraftBuilt 1980 · S/N 18504098 N61026Johnson David A · Dover, OHBuilt 1969 · S/N 15070744 N61028Berendes Jay R · Shullsburg, WIBuilt 1969 · S/N 15070746 N6102HSunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15284131 N6102RAerospace Aviation Services Inc · Wilmington, DEBuilt 1979 · S/N 172RG0084 N6102WPlane Blessings LLC · Montrose, COBuilt 1981 · S/N P21000715 N61030Balderrama Arturo · Mcminnville, ORBuilt 1969 · S/N 15070748 N61031Pacific Aircraft Services · Aurora, ORBuilt 1969 · S/N 15070749 N61033Dame John D · Omaha, NEBuilt 1969 · S/N 15070751 N61038Bartholomew Howard R Jr · Mechanicsburg, PABuilt 1969 · S/N 15070755 N6103ERadloff Adam E · Delaware, OHBuilt 1958 · S/N 46203 N6103NRed Leasing LLC · Juneau, AKS/N 20700194 N6103RAta Auto Service Inc · Wilmington, NCBuilt 1965 · S/N T210-0003 N6103SJohnson Robert J · Santa Barbara, CABuilt 1980 · S/N R18201611 N61041Pattison Aero Inc · Upland, CABuilt 1969 · S/N 15070758 N6104QSorby Jerry N · Fort Ransom, NDBuilt 1981 · S/N 15285129 N6104ULavy Brothers Farming · Biggs, CAS/N 21064901 N61051Crispin Michael J · Broadalbin, NYBuilt 1969 · S/N 15070765 N61052Secker-Walker Hugh E · Newburyport, MAS/N 15070766 N61055Booher Tabitha O · Livingston, TNBuilt 1969 · S/N 15070768 N61057Provenzano Jeremy E · Aurora, COBuilt 1969 · S/N 15070770 N6105FShaw Christopher S · Porterville, CABuilt 1968 · S/N 21059005 N6105QAero Quest LLC DBA · Olive Branch, MSBuilt 1981 · S/N 15285130 N6105SMy Sky LLC · Hays, KSBuilt 1980 · S/N R18201612 N6105VSchlesinger Henry R · Castalian Springs, TNBuilt 1980 · S/N 172RG0580 N61061Townsend John J · Valliant, OKBuilt 1969 · S/N 15070773 N61062Bate David F · Vanceburg, KYBuilt 1969 · S/N 15070774 N61064N61064 LLC · Forest Park, ILBuilt 1969 · S/N 15070775 N61067Connolly Luile A · Blaine, MNBuilt 1969 · S/N 15070777 N6106BBeck Brooks R · Spearman, TXBuilt 1957 · S/N 34106

Back to AD 87-20-03 R2