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.

N51BPBravo Papa Flight Training LLC · Wichita Falls, TXBuilt 1965 · S/N 28-2531 N51PGFly N' Fish LLC · Jacksonville, FLBuilt 1984 · S/N 32R-8529003 N51RAK And D Aviation Inc · Robbinsville, NJS/N 28-7105147 N51SWDelaware Valley Aviation Inc · Langhorne, PABuilt 1981 · S/N 28-8111048 N51WEColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2014 · S/N 2844148 N5200LDecker Michael · Baxter, TNBuilt 1967 · S/N 28-4490 N5200TUding Michael E · Sainte Genevieve, MOBuilt 1972 · S/N 28-7205246 N5201SVancuren Maryann · Owasso, OKBuilt 1970 · S/N 32-40885 N5201TOwen Richard D · Ridgecrest, CABuilt 1972 · S/N 28R-7235193 N5201WStevens Wayne E II · Denver, COBuilt 1961 · S/N 28-236 N5202SWilliams Christopher Lee · Wallingford, KYBuilt 1970 · S/N 32-40886 N5202TBartella Eric A · Canastota, NYBuilt 1978 · S/N 28R-7837207 N5203LMelnik George L · Wheeling, WVBuilt 1968 · S/N 28-4494 N5204LChappell Earl W · New Cumberland, WVBuilt 1967 · S/N 28-4495 N5205LPons Miguel E · Aptos, CABuilt 1967 · S/N 28-4496 N5205SAgrivation LLC · Indianola, IABuilt 1969 · S/N 32-40894 N5205THangar 9 Inc · Aberdeen, SDBuilt 1972 · S/N 28-7225337 N5205WAircraft 1821 LLC · North Charleston, SCBuilt 1961 · S/N 28-240 N5206LNora Jet LLC · Granbury, TXBuilt 1967 · S/N 28-4497 N5207LDon'T Panic! LLC · Vancouver, WABuilt 1967 · S/N 28-4498 N5207SOhio Air Enterprises LLC · Lancaster, OHBuilt 1969 · S/N 32-40898 N5208TGarrett Jerry M · Shreveport, LAS/N 28-7225353 N5209LKing Christian T · Rhinelander, WIBuilt 1967 · S/N 28-4501 N520AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2021 · S/N 28020049 N520ARSchool Of Missionary Aviation Technology · Ionia, MIBuilt 1992 · S/N 2837059 N520BBJ S Aviation Corp · Farmingdale, NYBuilt 2006 · S/N 2842257 N520CWCentral Washington University · Ellensburg, WABuilt 2017 · S/N 2843921 N520FLSiry Kristina · Mertztown, PABuilt 1971 · S/N 28-7125345 N520JWHangar 6 LLC · Saint Augustine, FLS/N 32-7940119 N520MAL3 Wolfpack Sigma LLC · Lenexa, KSBuilt 1996 · S/N 32-46020 N520XSwaz Aviation LLC · Mesa, AZBuilt 1978 · S/N 28-7816582 N5210LDewilde Lee Ray · Huslia, AKBuilt 1967 · S/N 28-4502 N5210T51st Aero Squadron LLC · Hoover, ALBuilt 1972 · S/N 28R-7235195 N5211LDuncan Timothy Scott · Sioux Falls, SDBuilt 1967 · S/N 28-4503 N5211WRupesh Patel · Waycross, GABuilt 1961 · S/N 28-247 N5212SHastings Reginald J · Brookshire, TXBuilt 1970 · S/N 32S-40904 N5213LSchultz Lillian I · Henderson, TXBuilt 1967 · S/N 28-4505 N5213WN5213w LLC · Clarksville, TNBuilt 1961 · S/N 28-249 N5215LMorehouse William S · Tucson, AZBuilt 1967 · S/N 28-4507 N5215SFive Generation Flyers LLC · Melbourne, FLBuilt 1970 · S/N 32-40909 N5215TBarr Perry L · Bethel, AKS/N 28-7225358 N5215WBurns Arlen B · Bellingham, WABuilt 1961 · S/N 28-251 N5216SSale Reported · Spearfish, SDSale reportedBuilt 1970 · S/N 32-40910 N5216TKntl Enterprises LLC · Boise, IDBuilt 1972 · S/N 28-7205247 N5216WSteed Moroni W · Moorcroft, WYBuilt 1961 · S/N 28-252 N5217LKenny Tommy D · Maryville, MOBuilt 1967 · S/N 28-4510 N5217TJahangiri Ali · Arlington, TXBuilt 1972 · S/N 28R-7235198 N5218LTjossem James · Thompsons Station, TNBuilt 1967 · S/N 28-4511 N5219LShanley William D · Orland Park, ILBuilt 1967 · S/N 28-4512 N521ASStanz John Trustee · Maple City, MIBuilt 1982 · S/N 32R-8229051

Back to AD 87-08-08 R3