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.

N545MASkywest Leasing Inc · St George, UTBuilt 2017 · S/N 2843865 N545WAStine Scott A · Vincennes, INBuilt 1968 · S/N 28R-30577 N545WHBledsoe Bobby H · Hot Springs, ARBuilt 2000 · S/N 32-46156 N545WRCumulus Aviation Services LLC · Port Orange, FLBuilt 1972 · S/N 28R-7235119 N5460NWylie David · Sharon Springs, NYBuilt 1968 · S/N 28-3800 N5461WGarvey David G · Erie, PAS/N 28-541 N5463WAngels Envy Aviation LLC · Denison, TXBuilt 1962 · S/N 28-543 N5465WCotrell Rick G Trustee · Troy, OHBuilt 1962 · S/N 28-609 N54665Registration Pending · Talking Rock, GARegistration pendingBuilt 1974 · S/N 28-7425233 N5467SBlach Edmund Jerome · Nashville, TNBuilt 1971 · S/N 28-7125125 N5467WGovender Sagren K Jr · Houston, TXBuilt 1962 · S/N 28-548 N5468WSitton David F · Mebane, NCBuilt 1962 · S/N 28-549 N546BNavigation Leasing LLC · Castle Rock, COBuilt 2019 · S/N 2881105 N546CACoast Flight Training And Management Inc · San Diego, CABuilt 2019 · S/N 2881279 N546CWCentral Washington University · Ellensburg, WABuilt 2019 · S/N 2881104 N5470WRegistration Pending · Bulverde, TXRegistration pendingBuilt 1962 · S/N 28-551 N5471WBartholomew Charles Scott · Newburyport, MABuilt 1962 · S/N 28-552 N5472TAdvantage Aviation Inc · Palo Alto, CABuilt 1972 · S/N 28R-7235234 N5473WMathews Derek A · Burlington, KYBuilt 1962 · S/N 28-555 N5474SHiggs Mark P · Monett, MOBuilt 1971 · S/N 28-7125128 N5475WWing & A Prayer LLC · Moreland, GABuilt 1962 · S/N 28-557 N5476WTalon Aviation LLC · Greenville, MIBuilt 1962 · S/N 28-558 N5477WAchi Inc · San Jacinto, CABuilt 1962 · S/N 28-559 N547BWBland Gregory A · Florence, KYBuilt 1974 · S/N 28R-7435217 N547CACareer Flyers LLC · Crittenden, KYBuilt 1975 · S/N 28-7625096 N547CWCentral Washington University · Ellensburg, WABuilt 2020 · S/N 2881383 N547FLNgugi Samson W · El Paso, TXBuilt 1971 · S/N 28-7125380 N547KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843867 N547RSMawson Richard · Katy, TXBuilt 1964 · S/N 28-2021 N547SCSpartan Education LLC · Tulsa, OKS/N 2881322 N5480WAikin Denver · Owasso, OKS/N 28-563 N5481WBawden Frederick M · Brookfield, WIBuilt 1962 · S/N 28-564 N5487Rhj Investments LLC · Show Low, AZBuilt 1967 · S/N 32-40110 N5487FKettlehut Alan W · Ceresco, NEBuilt 1976 · S/N 28-7715141 N5488TWestphal Ronald R · Aurora, ILBuilt 1972 · S/N 28-7205264 N548CWCentral Washington University · Ellensburg, WABuilt 2020 · S/N 2881384 N548JMLarock Guy · New Bedford, MABuilt 1979 · S/N 28R7931018 N548SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881340 N5490WHobbs Alicia · Folsom, CABuilt 1962 · S/N 28-575 N5492WSky Park Cherokees Inc · Felton, CABuilt 1962 · S/N 28-577 N5495THill Mark D · Magnolia, TXS/N 28R-7235236 N5495WWings Over Lake Norman LLC · Mooresville, NCBuilt 1962 · S/N 28-580 N5496WMaddux Dawayne E · Weeki Wachee, FLBuilt 1962 · S/N 28-582 N5497WJethro Charter Flights LLC · Jacksonville, NCBuilt 1962 · S/N 28-583 N5498WBas Part Sales LLC · Greeley, COS/N 28-584 N5499FIndy Air Sales LLC · Anderson, INS/N 28-7790127 N5499WVerchick Peter A · Jacksonville, FLBuilt 1962 · S/N 28-495 N549SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881341 N549WSBoraam Aviation Inc · Prospect Heights, ILBuilt 1997 · S/N 3246073 N54BG54 Bravo Golf LLC · Austin, TXS/N 32R-7887079

Back to AD 87-08-08 R3