Skip to content

Registered aircraft · 5,443

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:2016-07-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21') 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:2016-07-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
  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:2016-07-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
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.

N9721KJet Time Consulting LLC · Gilbert, AZBuilt 1976 · S/N 28-7690277 N9722CRobbins Joseph R · Madison, ALBuilt 1978 · S/N 28R-7837219 N9724KGoodwin Thomas R · Martinsville, INBuilt 1976 · S/N 28-7690278 N972CPlainfield Aviation Inc · Plainfield, ILBuilt 2002 · S/N 2843538 N972LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 2844172 N972MWKo Hee Sun · Norwood, NJBuilt 1999 · S/N 2844019 N972TFAir Fleet Holdings LLC · Missoula, MTS/N 2881595 N973LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 2844173 N9745CWashington State Community College District 17 · Spokane, WABuilt 1978 · S/N 28-7816523 N974ABPiper Aircraft Inc · Vero Beach, FLS/N 28010093 N974ACNaples Air Center Inc · Naples, FLBuilt 1978 · S/N 28-7916126 N974MATerriair Aviation LLC · Littleton, COS/N 28-8116288 N9752CAero-Sphere Inc · Longmont, COBuilt 1978 · S/N 28-7816524 N975ACNaples Air Center Inc · Naples, FLBuilt 1978 · S/N 28-7916121 N975LEBlue Borracho LLC · Manitou Springs, COBuilt 1975 · S/N 28-7690001 N9760CStreet Steven J · Rochester, MIBuilt 1978 · S/N 28-7816526 N9764KSchoff Wardell R · Hamilton, MOBuilt 1977 · S/N 28R-7837038 N9769FFrost Aviation Services Inc · Las Cruces, NMBuilt 2023 · S/N 28020114 N976ABPiper Aircraft Inc · Vero Beach, FLS/N 28010096 N976ACNaples Air Center Inc · Naples, FLBuilt 1981 · S/N 28-8116308 N9777MEgs Air LLC · St Thomas, VIBuilt 2004 · S/N 2844116 N977ACNaples Air Center Inc · Naples, FLBuilt 1988 · S/N 2816073 N977MASnodgrass James T · Gallipolis, OHBuilt 1980 · S/N 28-8116032 N977NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 2881889 N977SCAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881876 N9782CTranel Aviation LLC · Port Edwards, WIBuilt 1978 · S/N 28-7890443 N9787CSampson James M · Oriskany, NYBuilt 1978 · S/N 28-7890444 N9787KKestrel Aviation LLC · Driftwood, TXBuilt 1977 · S/N 28-7890180 N9789CLinares Carlos W · Concord, CABuilt 1978 · S/N 28R-7837221 N978ACNaples Air Center Inc · Naples, FLBuilt 1989 · S/N 2841220 N979AArcher Aero LLC · Wilmington, DEBuilt 2014 · S/N 2843805 N979CSkywest Leasing Inc · St George, UTBuilt 2003 · S/N 2843547 N97PFSoaring Eagles Flying Svc Ltd · Edwards, ILBuilt 1980 · S/N 28-8116068 N97UAManufacturing Services And Solutions LLC · Lake Villa, ILBuilt 1978 · S/N 28R7837163 N9807CAllen Vincent J · Mckinney, TXBuilt 1978 · S/N 28-7816530 N9809KS&S Investment Solutions LLC · Lakeland, TNBuilt 1977 · S/N 28R-7837039 N980AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843806 N980ACNaples Air Center Inc · Naples, FLBuilt 2001 · S/N 2844051 N980EPiper Aircraft Inc · Vero Beach, FLS/N 28010101 N980TFAir Fleet Holdings LLC · Missoula, MTBuilt 2022 · S/N 2881596 N9810CTester Gordon T · Santa Maria, CAS/N 28-7816531 N9812CHodgs Sidney L · Cimarron, KSBuilt 1978 · S/N 28-7890445 N9814CZechlin Margaret Christine · Novato, CABuilt 1978 · S/N 28-7890446 N9817KN9817k LLC · Fredricksburg, VABuilt 1977 · S/N 28R-7837040 N982RMInspire Aviation LLC · Magnolia, TXS/N 28-7790423 N9839KP P I Consulting LLC · Gladstone, ORBuilt 1977 · S/N 28-7816198 N9843KN9843k LLC · Melbourne, FLBuilt 1977 · S/N 28-7890187 N9844SSpace Coast Aircraft Co · Merritt Island, FLBuilt 2002 · S/N 2842148 N9845KRaleigh Flying Club LLC · Chapel Hill, NCBuilt 1977 · S/N 28-7890188 N9855SAri Ben Aviatior Inc · Fort Pierce, FLBuilt 2002 · S/N 2842151

Back to AD 2016-07-21