Skip to content

Registered aircraft · 72,010

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-10-06-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:87-10-06-R1') 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-10-06-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:87-10-06-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.

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-10-06-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:87-10-06-R1')
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.

N5200TUding Michael E · Sainte Genevieve, MOBuilt 1972 · S/N 28-7205246 N52012Skylens LLC · Hammond, LABuilt 1980 · S/N 17274393 N52013Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 17274394 N5201CCordero Jose Robert · El Paso, TXBuilt 1978 · S/N 24-0577 N5201DGriffin Thomas S · Spartanburg, SCBuilt 1978 · S/N 24-0578 N5201EGholizadehkasgari Mary Ambanoo · Jacksonville, FLBuilt 1978 · S/N 17271767 N5201HGorge Winds Aviation Inc · Fairview, ORBuilt 1975 · S/N 17265374 N5201LMelchiorre Joseph G Jr · Milton, DEBuilt 1978 · S/N 24-0580 N5201NMarr Christopher M · Morrisville, NCBuilt 1978 · S/N 24-0581 N5201QAdams Clive P · Hendersonville, TNBuilt 1973 · S/N 17261770 N5201RWest Florida Flying Service LLC · Safety Harbor, FLBuilt 1974 · S/N 17263418 N5201SVancuren Maryann · Owasso, OKBuilt 1970 · S/N 32-40885 N5201TOwen Richard D · Ridgecrest, CABuilt 1972 · S/N 28R-7235193 N5201UMccrary Enterprises LLC · Port Jefferson, OHBuilt 1978 · S/N 24-0582 N5201VMg Aircraft Inc · Fort Lauderdale, FLBuilt 1978 · S/N 24-0583 N5201WStevens Wayne E II · Denver, COBuilt 1961 · S/N 28-236 N5201XSims Raymond H · Navarre, FLBuilt 1978 · S/N 24-0584 N5201YShared Momentum LLC · Wilmington, DEBuilt 1978 · S/N 24-0585 N5202Fischer Robert L · Oakland, ORBuilt 2019 · S/N 5202 N5202EMcdowell William R · Corpus Christi, TXBuilt 1978 · S/N 17271768 N5202JLizco Aviation LLC · Jackson, MOBuilt 1980 · S/N 17273729 N5202RHahn Douglas Keith · Waldport, ORBuilt 1974 · S/N 17263419 N5202SWilliams Christopher Lee · Wallingford, KYBuilt 1970 · S/N 32-40886 N5202TBartella Eric A · Canastota, NYBuilt 1978 · S/N 28R-7837207 N5202WKrishna Ashwin G · Staten Island, NYBuilt 1961 · S/N 28-237 N5203DAcumen Aerotech LLC · Rogers, TXBuilt 1979 · S/N 17272446 N5203LMelnik George L · Wheeling, WVBuilt 1968 · S/N 28-4494 N5203PFischer Steven A Trustee · Cary, ILBuilt 1958 · S/N 24-226 N5203RGehman David W · Atmore, ALS/N 17263420 N52048Time Flyers LLC · East Troy, WIBuilt 1980 · S/N 17274399 N5204LChappell Earl W · New Cumberland, WVBuilt 1967 · S/N 28-4495 N5204MZenteno Nelson Jr · Winter Haven, FLBuilt 1978 · S/N MB-878 N5204SHildahl Gene G · Chelan, WABuilt 1980 · S/N R18201518 N5204VNimier Alexander M · Chatsworth, CABuilt 1980 · S/N 172RG0468 N5205BHarms Frederick L · Hesperia, CABuilt 1956 · S/N 1068 N5205DAlleghany Flying Club Inc · Hyndman, PABuilt 1979 · S/N 17272448 N5205LPons Miguel E · Aptos, CABuilt 1967 · S/N 28-4496 N5205PCope N H · Lamesa, TXBuilt 1958 · S/N 24-228 N5205RValley Pilots Flying Club Inc · Martinez, CABuilt 1974 · S/N 17263422 N5205SAgrivation LLC · Indianola, IABuilt 1969 · S/N 32-40894 N5205THangar 9 Inc · Aberdeen, SDBuilt 1972 · S/N 28-7225337 N5205UVoloshin Vitaly Alexandrovich · Seattle, WABuilt 2002 · S/N T18208153 N5205WAircraft 1821 LLC · North Charleston, SCBuilt 1961 · S/N 28-240 N52062Rpm Inc Flying Club · South Holland, ILBuilt 1980 · S/N 17274403 N5206BStaffeldt David S · Hardwood, MIS/N 1069 N5206LNora Jet LLC · Granbury, TXBuilt 1967 · S/N 28-4497 N5206PHyde Roy Wiliam · Sacramento, CABuilt 1958 · S/N 24-229 N5206RNewlon Rudolf W · Encinitas, CAFirst renewal noticeS/N 17263423 N5206YHart Lewis W DBA · Rexburg, IDBuilt 1962 · S/N 27-2254 N52072Wicked Wings Aviation LLC · Dover, DEBuilt 2002 · S/N 18281137

Back to AD 87-10-06 R1