Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N3941XBroshchan Ruslan · Jackson, MSBuilt 1975 · S/N 32-7640001 N3942TAuburn Valley LLC · Farmington, MNBuilt 1967 · S/N 28R-30285 N3942WLarkin Jason · Zeeland, MIBuilt 1967 · S/N 32-931 N3943WCox Aviation LLC · Debord, KYBuilt 1967 · S/N 32-892 N3943XSuberg Valerie G · Windsor, CABuilt 1975 · S/N 28R-7535362 N3944FHenley Johnny · Trenton, NCBuilt 1976 · S/N 28-7615432 N3944KPeiker Laramie · Revillo, SDBuilt 1967 · S/N 28-23819 N3944WCatlin Flying Service LLC · Twisp, WABuilt 1967 · S/N 32-932 N3944XClark Nicholas J · Wilmington, DEBuilt 1975 · S/N 28R-7535363 N39456Lorber Robert M · East Brunswick, NJBuilt 1978 · S/N 28-7816660 N39457Pro-Aire Inc · Chisago City, MNBuilt 1978 · S/N 28R-7837297 N39459Hubert L Hooks Jones Chpt Of Tuskegee Airmen Inc · Denver, COBuilt 1978 · S/N 32R-7885219 N3945FBrougnton Eric S · Catlettsburg, KYBuilt 1976 · S/N 28-7690463 N3945KFisher Knute A · Kensington, CABuilt 1967 · S/N 28-23821 N3945RJpx Aero Club Corp · East Hampton, NYBuilt 1970 · S/N 28-5854 N3945TElsinger Vincent R · Pierre, SDS/N 28R30288 N3945WSouth Bay Aviation Inc · Torrance, CAS/N 32-894 N3945XKatoozian Kambiz · Kirkland, WABuilt 1975 · S/N 32-7640002 N39464Wise Stephen T · Denver, COBuilt 1978 · S/N 32R-7887093 N3946TPotter Allen W · Clinton Corners, NYBuilt 1967 · S/N 28R-30289 N39472Moore Tucker S · Keswick, VABuilt 1978 · S/N 28-7816662 N39476Neal John W · Pt Pleas Bch, NJBuilt 1978 · S/N 28R-7803348 N39477Marti Michael · Kasson, MNBuilt 1978 · S/N 28R-7803349 N39478Jacies Wings LLC · Port Isabel, TXBuilt 1978 · S/N 32R-7885221 N39479Pgd Flyers LLC · Newark, DES/N 32R-7885222 N39489Dlr Rentals LLC · Elkhart, INBuilt 1978 · S/N 32R-7887096 N3948KMcilroy William E · Dyer, INBuilt 1967 · S/N 28-23824 N3948TSchmidt Stephen M · Tipp City, OHS/N 28R-30291 N39496Texter John F · Saint Ignace, MIBuilt 1978 · S/N 28-7890536 N3949MMatthews Devon · San Jose, CABuilt 1978 · S/N 28R-7803204 N3949THathaway Devon Scott · Buna, TXS/N 28R-30292 N3949XBlue Ridge Flyers · Leesburg, VABuilt 1975 · S/N 28R-7535365 N394DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843858 N394DSP&R Operations Ltd · Muscatine, IABuilt 1980 · S/N 28-8116040 N394HPMms Aviation LLC · Muscle Shoals, ALBuilt 1993 · S/N 3213066 N394LESage Aviation LLC · Milanville, PABuilt 1976 · S/N 32R-7680358 N39500Steen Farms LLC · Newhebron, MSBuilt 1978 · S/N 28-7911002 N39503Demmery Daniel D · Port Saint Lucie, FLBuilt 1978 · S/N 32R-7885224 N39506Vadas Roe C · Paducah, KYBuilt 1978 · S/N 32R-7887098 N3950MScifly LLC · San Diego, CAS/N 32-7840075 N3950TPark 46 LLC · Savannah, GABuilt 1967 · S/N 28R-30293 N3950WQctr Parts LLC · Big Rapids, MIBuilt 1967 · S/N 32-899 N39512Tcb Consulting LLC · Yorba Linda, CABuilt 1978 · S/N 28-7890537 N39513Vitale F Richard · Colts Neck, NJBuilt 1978 · S/N 28R-7837300 N39517Dernoshek Logan · Kannapolis, NCBuilt 1978 · S/N 32R-7885226 N3951TScott Stanley L · Milton, FLBuilt 1967 · S/N 28R-30294 N3951WRiebecing Karl F · Whitefish, MTBuilt 1967 · S/N 32-900 N39525Hancock Charles · Baxter, TNBuilt 1978 · S/N 32R-7887101 N39526Nextgen Air Engineering Inc · Cheyenne, WYBuilt 1978 · S/N 32R-7887102 N39527Amazonie Inc Trustee · Wilmington, DEBuilt 1978 · S/N 32R-7887103

Back to AD 87-08-08 R3