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.

N4785LTranswestern Air Service Inc · Golden, COBuilt 1967 · S/N 28-4120 N47868Heartland Airplanes LLC · Olathe, KSFirst renewal noticeS/N 28-7890147 N47869N47869 LLC · Spanish Fork, UTBuilt 1977 · S/N 28R-7837008 N4786LZayas Omar · Fontana, CABuilt 1967 · S/N 28-4122 N47874Matthews John M · Mount Pleasant, TXBuilt 1977 · S/N 28R-7803032 N47881Griffin Jack D · Hamilton, OHBuilt 1977 · S/N 28-7816151 N47882Trident Aircraft Inc · Easton, MDBuilt 1977 · S/N 28-7816152 N47885Dynasty Adventure Inc · Mentone, CABuilt 1977 · S/N 28-7890148 N47886N47886 LLC · Dover, DEBuilt 1977 · S/N 28-7890149 N47891Pearson Joe D · Boise, IDBuilt 1977 · S/N 28R-7803035 N47899Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7816153 N478AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843746 N478FLLadd Charles B · Cornelia, GABuilt 1971 · S/N 28-7125284 N478MAHarpazo Aviation LLC · Lake City, FLBuilt 1966 · S/N 3240265 N478MDAirmart Inc · Lexington, KYBuilt 2005 · S/N 3257376 N478PAlfaro Julio C · Norwalk, CABuilt 1968 · S/N 28-24807 N478PCSaint Louis University · Saint Louis, MOBuilt 2019 · S/N 2881201 N47905Hanson Larry A · Starkville, MSBuilt 1977 · S/N 28-7816155 N47906Brooks Jerry D · Fairmont, MNBuilt 1977 · S/N 28-7816156 N47907Macaulay Mark · Austin, TXBuilt 1977 · S/N 28-7890150 N4790LFrodge Alan L · Crawfordsville, INBuilt 1967 · S/N 28-4126 N47912Maxey Russell J · Midland, TXFirst renewal noticeS/N 28R-7803037 N47914Ciolkowski Edward L · Webster, NYBuilt 1977 · S/N 32-7840018 N47918Hay Yotam · Johnson City, TNBuilt 1977 · S/N 28-7816158 N4791LWiley Scott C · Dothan, ALBuilt 1967 · S/N 28-4127 N47920Barbeau Daniel P · Tullahoma, TNBuilt 1977 · S/N 28-7816160 N47923Stoehr Steven C Trustee · Ewing, NES/N 28-7890153 N47924Laplant Lloyd P Jr · El Cajon, CABuilt 1977 · S/N 28-7890154 N47929Hylton Fitzroy C · Miramar, FLFirst renewal noticeBuilt 1977 · S/N 28-7816161 N4792TBrooks Donald D · Baton Rouge, LABuilt 1972 · S/N 28R-7235109 N4793LWhitley Carol E · Kingwood, TXBuilt 1967 · S/N 28-4130 N4793SArkansas Pilots For Christ Inc · Paragould, ARBuilt 1969 · S/N 32-1180 N47941Engineering Forensics Inc · Glen Burnie, MDS/N 28-7816167 N47943Louiewex Corp · Dover, DES/N 28-7890157 N47945Countee Roger Brendan · Los Angeles, CABuilt 1977 · S/N 28R-7837018 N4794LFerraro Henrik L · Grand Island, NYBuilt 1967 · S/N 28-4131 N47953Mountain Aviation Associates LLC · Midland, TXBuilt 1977 · S/N 28-7816169 N47954Jennings James A · Fredericktown, OHS/N 28-7816170 N47955Southeastern Minnesota Flying Club Inc · Rochester, MNBuilt 1977 · S/N 28-7890159 N4795LN383j LLC · Henderson, NVBuilt 1967 · S/N 28-4132 N4795TCammack Van R Jr · Willow Park, TXBuilt 1972 · S/N 28R-7235110 N47961Thomas Brian E · Virginia Beach, VABuilt 1977 · S/N 32R-7880029 N47965Reid Brian M · Boise, IDS/N 28-7890156 N47968Grimes Mike · Yukon, OKBuilt 1977 · S/N 28-7816173 N47969Thomason Eric A · Georgetown, TXBuilt 1977 · S/N 28-7816174 N47971Five X Five Flight Inc · The Woodlands, TXBuilt 1977 · S/N 28-7890163 N47977Cossi Restaurant Corp · Ballston Spa, NYBuilt 1977 · S/N 32R-7880031 N4797SSmith Matthew · Seattle, WABuilt 1969 · S/N 32-1182 N47981Sabetha Flyers Inc · Sabetha, KSBuilt 1977 · S/N 28-7890164 N47987Mongo Corp · Santa Fe, NMBuilt 1977 · S/N 28R-7803052

Back to AD 87-08-08 R3