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.

N787DJDgj Tex LLC DBA · Cleburne, TXBuilt 1977 · S/N 28-7816014 N787FBHot Wings Aviation LLC · Fishers, INBuilt 2025 · S/N 28020210 N787NDUnd Aerospace Foundation · Grand Forks, NDS/N 2881306 N787RPSilver Fox Aircraft LLC · Queen Creek, AZBuilt 1985 · S/N 28-8690025 N787TFAir Fleet Holdings LLC · Missoula, MTBuilt 2022 · S/N 2881555 N787TKIal Corp · Lewes, DES/N 2881144 N788JAHot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020088 N789FBHot Wings Aviation LLC · Fishers, INBuilt 2025 · S/N 28020211 N789JAYale Companies LLC DBA Hot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020089 N789NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881307 N789SVPaulukaitis Robert Adam · Hudson Oaks, TXBuilt 2023 · S/N 2881632 N78BGKdrd Holdings LLC · Texas City, TXBuilt 1977 · S/N 28-7890100 N78DJKing David V · Mars, PABuilt 1978 · S/N 28R-7837171 N78JMDye William M · Atlanta, GABuilt 1976 · S/N 28-7690430 N78QBPandion Aviation LLC · West Chester, PABuilt 1978 · S/N 28R-7837308 N78TACti Aircraft Leasing LLC · Memphis, TNBuilt 2020 · S/N 2881295 N78TMBowlin Ronald R · Camarillo, CABuilt 1977 · S/N 28-7890216 N78WARtd Aviation LLC · Hillsborough, NJBuilt 1977 · S/N 28R-7837077 N7900CSdd Aviation LLC · Thomasville, GABuilt 1975 · S/N 28-7690087 N7901CFrost Aviation Alliance LLC · North Hollywood, CABuilt 1975 · S/N 28-7690088 N790FBEagle Aviation LLC · Fishers, INBuilt 2025 · S/N 28020212 N790UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020169 N791CRPryll Gary · Cape Coral, FLBuilt 1980 · S/N 28-8090259 N792AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843795 N7933CLaytham Ricky A · Coatesville, PAS/N 28-7690090 N7938CVolar Corp · El Cajon, CABuilt 1979 · S/N 28-7916428 N793AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843796 N793CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881765 N7944CAugter Gary K · Mcalester, OKS/N 28-7690091 N794AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843797 N794BKMaxlines LLC · Fairfax, CABuilt 1979 · S/N 28-7916556 N7965FLustig Barry J · San Ramon, CABuilt 1976 · S/N 28-7790229 N7967CDeer Park Air Center LLC · Deer Park, WABuilt 1975 · S/N 28-7690094 N7969FWylie Timothy M · Santa Cruz, CAS/N 28-7790230 N7972CJust Plane People LLC · Irvine, CABuilt 1975 · S/N 28-7690095 N799DAJumping Cash Cow Ranch LLC · Lakeland, FLBuilt 2025 · S/N 2881851 N79MSUaa International Inc · La Verne, CABuilt 1978 · S/N 28-7990154 N79NANorthampton Aeronautics Inc · Northampton, MABuilt 1977 · S/N 28-7816276 N79PAFlightgest Academy LLC · Morrisville, NCBuilt 2020 · S/N 2881293 N79SFSterling Flight Training LLC · Jacksonville, FLS/N 2881378 N7UULazy R Endeavors LLC · Orient, OHS/N 2843139 N7VWSantoro Joseph A · Phoenix, AZBuilt 1977 · S/N 28-7890145 N800CTPakiri Aviation LLC · San Antonio, TXBuilt 1981 · S/N 28-8290069 N800FWPaphos Airways LLC · Farmingdale, NYS/N 28-8216060 N800SLParagon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020192 N800VVCarver Aero LLC · Muscatine, IABuilt 1981 · S/N 28-8216080 N8018NMacris Troy C · Tarpon Springs, FLBuilt 1981 · S/N 28-8216082 N8019VJuliet One LLC · Newark, DEBuilt 1981 · S/N 28-8290074 N801FCN801fc LLC · Belle Chasse, LABuilt 1980 · S/N 28-8016285 N802CMN802cm LLC · Lebanon, MOBuilt 2002 · S/N 2843541

Back to AD 2016-07-21