Skip to content

Registered aircraft · 54,017

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.

N500BSCentral Aircraft Sales And Leasing LLC · Columbia, MOBuilt 1971 · S/N 17260303 N500DGraham Douglas R · Palmer, AKS/N 31460 N500DZEz Aviation LLC · Orlando, FLFirst renewal noticeS/N 172RG0362 N500GDElizondo Ernesto · Laredo, TXBuilt 1976 · S/N 17267505 N500JFXota LLC · Litchfield, ILBuilt 1976 · S/N 18265093 N500SUOhio State University · Columbus, OHBuilt 1974 · S/N A1500486 N500TFPine Bluff Police Department · Pine Bluff, ARBuilt 1977 · S/N 17268711 N50100Best Bobby R · Goldsboro, NCS/N 15069062 N50106Walker Charles B · Angleton, TXBuilt 1968 · S/N 15069065 N50108Gibbs Robert I · Ravenswood, WVBuilt 1968 · S/N 15069066 N50110Coger Charles E · Huntsville, ARBuilt 1968 · S/N 15069068 N50115Affordable Flight Time LLC · Eagle River, AKS/N 15069072 N50118Carver Alan H · Winder, GAS/N 15069074 N5011ABores Scott J · Huron, OHS/N 28011 N5011XPro Air LLC · Alexandria, LAS/N 185-0033 N5012REmd Aviation LLC · Carlsbad, CABuilt 1978 · S/N R18200626 N50131Kotval Matthew J · Milaca, MNS/N 15069079 N50132Dunaire LLC · Mechanicsburg, PABuilt 1968 · S/N 15069080 N50133Pilot Legal Funding Inc · Fresh Meadows, NYBuilt 1968 · S/N 15069081 N50138Kalb Brian A · Mechanicsburg, OHBuilt 1968 · S/N 15069083 N5013AReed Ted R · San Angelo, TXBuilt 1955 · S/N 28013 N5013RBarxbar Aviation LLC · Mesa, AZBuilt 1974 · S/N 17263254 N50140Air Devices Company LLC · Alpena, MIS/N 15069084 N50146Aero Sceince International LLC · Martinez, GABuilt 1968 · S/N 15069089 N5014DHall Matthew A · Coeur D Alene, IDBuilt 1958 · S/N 51114 N5014RCooper Flying Inc · Lamesa, TXBuilt 1976 · S/N 18502978 N50150Above All Aviation Inc · Santa Barbara, CABuilt 1968 · S/N 15069092 N50151Thums April M · Murfreesboro, TNBuilt 1968 · S/N 15069093 N50155Haupricht Andy C · Sanford, NCBuilt 1968 · S/N 15069097 N50156Humanic Thomas J · Columbus, OHBuilt 1968 · S/N 15069098 N50160Morales-Escareno Rogelio · San Diego, CAS/N 15069102 N5016AMoore Wallace Frank · Mckinney, TXBuilt 1955 · S/N 28016 N5016DCain Arthur W · Kenilworth, NJRegistration revokedBuilt 1958 · S/N 44720D N50170Moroney Aviation LLC · Chugiak, AKBuilt 1968 · S/N 15069106 N50171Evans Mark E · Heber Springs, ARS/N 15069107 N50177Dudley Lee B · Passadumkeag, MEBuilt 1968 · S/N 15069110 N5017AMeixell David Matthew · Santa Maria, CABuilt 1955 · S/N 28017 N5017DGraham Thomas V · San Rafael, CAS/N 51117 N5017RR&R Leasing LLC · Fargo, NDBuilt 1974 · S/N 17263258 N5017UBen Allen LLC · Wilmington, DEBuilt 1963 · S/N 206-0017 N50180Robbins Richard T · Ketchikan, AKS/N 15069112 N50181Debelius Enemark Peter C · Crawfordville, FLBuilt 1968 · S/N 15069113 N50184Wietecha Jack · Millington, ILBuilt 1968 · S/N 15069115 N50188Ryburn Michael D · Basehor, KSBuilt 1968 · S/N 15069119 N5018ABadger Daniel J · Yellow Springs, OHS/N 28018 N50193Folsom Gary A · Marianna, FLBuilt 1974 · S/N 17264196 N50194Brouillette Jakob D · Daleville, ALS/N 15069124 N5019DNobel John C · Brandon, FLBuilt 1958 · S/N 51119 N5019ERegistration Pending · Wilbur, WARegistration pendingBuilt 1958 · S/N 50319 N501ACNka Inc · Wilmington, DEBuilt 1979 · S/N 18266922

Back to AD 87-20-03 R2