Registered aircraft · 27,480

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

N1001A1st Avenue Ttc LLC · Los Angeles, CAS/N CG3 N1002HSmith Michael S · Anchorage, AKBuilt 1997 · S/N 23038C N10033Thunderfighter LLC · Englewood, COS/N 172S9797 N1004DGiezen Jurgen J · Fairfax, VAS/N 26001C N1004EUnison Air LLC · Palo Alto, CABuilt 2005 · S/N 172S9872 N1004NStokes David A · Burton, MIBuilt 1972 · S/N 167 N1005ESemaska Victor J · Kensington, CTBuilt 1977 · S/N 299-77 N1006VLanier Equipment Leasing LLC · Gainesville, GABuilt 2005 · S/N 172S9805 N1007UKallam Jerry · Palmer, AKBuilt 1998 · S/N 23047C N1008CBat Flying LLC · Blue Earth, MNBuilt 1981 · S/N 24-1100 N1008WRay Jonas · Palmer, AKS/N 23022C N1009EAven Michael D · Georgetown, INBuilt 1977 · S/N 606-77 N100AESale Reported · Spencer, NESale reported, pending cancellationBuilt 1978 · S/N 32R-7985058 N100DDCook Allen J · Aurora, COBuilt 1948 · S/N NAV41518 N100EEConcho Aviation LLC · Sterling City, TXBuilt 2006 · S/N 11028 N100ENRegistration Pending · Downingtown, PARegistration pending, pending cancellationS/N 816 N100EUSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2021 · S/N 28020030 N100GLWaco Aircraft Corp · Battle Creek, MIBuilt 2021 · S/N 1215 N100HWYale Companies LLC · Fishers, INBuilt 2025 · S/N 2881884 N100HX14 Aero Spaces LLC · Wilmington, DEBuilt 2008 · S/N 18282087 N100JGClub Cherokee Inc · Crystal, MNBuilt 1988 · S/N 3213019 N100JVKremers Gary · Zeeland, MIBuilt 2012 · S/N 40992 N100KYRegistration Pending · Weston, FLRegistration pendingBuilt 1987 · S/N 901 N100LED&J Training Planes LLC · Logan, UTBuilt 2023 · S/N 172S13000 N100LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2025 · S/N 172S13292 N100LGFlyd Pipers Inc · Dyer, INBuilt 1980 · S/N 28-8011113 N100LULynn University Inc · Boca Raton, FLBuilt 1997 · S/N 17280075 N100LWN100lw LLC · Hickory, NCBuilt 1980 · S/N 32-8006091 N100MPMeyer Christopher R · Colchester, CTBuilt 1976 · S/N 1-0038 N100NYAplustill Keith A · Los Osos, CABuilt 1985 · S/N 24-1526 N100PBDoobie Air LLC · Wilmington, DEBuilt 1978 · S/N 61P05847963257 N100PMPegasus Air LLC · Louisville, KYBuilt 2004 · S/N 172S9599 N100PPExplore Helicopters LLC · Lexington, ALBuilt 1975 · S/N 412 N100QBShutt Ryan T · Eden, NYBuilt 1979 · S/N R18201185 N100SELanger Paul Hubert · Gainesville, TXBuilt 1971 · S/N RM-1 N100TCMckinney Richard P · Fayeteville, ARBuilt 1973 · S/N 28R-7335370 N100UKFurlow Paul S · Annapolis, MDBuilt 2015 · S/N 41541 N100UVJohn B Bateman · Draper, UTBuilt 2004 · S/N 40.405 N100WLLively Wade C · Spring Branch, TXBuilt 2012 · S/N 80683 N100YVPalmy LLC · Lander, WYBuilt 1991 · S/N 243194 N1010EIndian Aire LLC · Water Mill, NYBuilt 2006 · S/N 40382 N1010TReilly Patrick W · Rockford, ILBuilt 2024 · S/N 1107 N1010XWright John D · Brentwood, TNBuilt 2025 · S/N MXS-005 N1010YGregory Kenneth · Crowley Lake, CABuilt 1970 · S/N 28R-35800 N1011JJames Robert L · East Setauket, NYBuilt 1972 · S/N 11 N1012XSunbeam Air Operations LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535215 N1012YNelson Susan P · Kirkland, WABuilt 2005 · S/N 18281543 N1013PSentinel Services Group LLC · Brooksville, FLS/N MC-428 N1013XBtm Aero LLC · Mansfield, TXS/N 28R-7535216 N1014BClark Joseph C · Avondale, PABuilt 2025 · S/N 42904

Back to AD 96-23-03