Registered aircraft · 21,465

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:73-10-02') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-10-02') 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:73-10-02')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-10-02')
  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:73-10-02')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-10-02')
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 N1002GFlying Fox Aviation LLC · Idaho Falls, IDBuilt 2000 · S/N 27-0295 N1004DGiezen Jurgen J · Fairfax, VAS/N 26001C N1004NStokes David A · Burton, MIBuilt 1972 · S/N 167 N1005XSigler Lanny · Albuquerque, NMBuilt 2000 · S/N 27-0302 N1007VSmith Loren Dallas · Great Falls, MTS/N 73-31060 N100AESale Reported · Spencer, NESale reported, pending cancellationBuilt 1978 · S/N 32R-7985058 N100BJAllen David L · Eastpoint, FLBuilt 1966 · S/N 32-40077 N100BSC & C Logging LLC · Kelso, WABuilt 1966 · S/N 27-3431 N100CNAileron Aviation Inc · Sparta, TNS/N 27-7754050 N100DDCook Allen J · Aurora, COBuilt 1948 · S/N NAV41518 N100EEConcho Aviation LLC · Sterling City, TXBuilt 2006 · S/N 11028 N100ELLeading Edge Leasing LLC · Wilmington, DES/N 310Q-0688 N100EMKentem100 LLC · Asheboro, NCBuilt 1981 · S/N 31-8152196 N100ENRegistration Pending · Downingtown, PARegistration pending, pending cancellationS/N 816 N100EUSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2021 · S/N 28020030 N100GSPegasus Florida I Inc · San Diego, CABuilt 1974 · S/N P-301 N100HWYale Companies LLC · Fishers, INBuilt 2025 · S/N 2881884 N100JGClub Cherokee Inc · Crystal, MNBuilt 1988 · S/N 3213019 N100JRLumland Properties LLC · Winchester, VABuilt 1969 · S/N 31-599 N100JVKremers Gary · Zeeland, MIBuilt 2012 · S/N 40992 N100KYRegistration Pending · Weston, FLRegistration pendingBuilt 1987 · S/N 901 N100LWN100lw LLC · Hickory, NCBuilt 1980 · S/N 32-8006091 N100NESanborn Map Co Inc · Colorado Springs, COS/N 31-7712022 N100NYAplustill Keith A · Los Osos, CABuilt 1985 · S/N 24-1526 N100POut Island Magic LLC · Gainesville, FLBuilt 1982 · S/N 31-8252019 N100PBDoobie Air LLC · Wilmington, DEBuilt 1978 · S/N 61P05847963257 N100RTRanch 100 LLC · Fort Pierce, FLS/N 31-808 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 N100VFMeridian Aviation N100vf LLC · Mobile, ALBuilt 1977 · S/N 32R-7780539 N100WDEveryday Medicine LLC · Nicholasville, KYBuilt 1982 · S/N 32-8224008 N100XRTomsis Corp · Panama City, FLBuilt 1981 · S/N 31-8152169 N1010EIndian Aire LLC · Water Mill, NYBuilt 2006 · S/N 40382 N1010TReilly Patrick W · Rockford, ILBuilt 2024 · S/N 1107 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 N1013XBtm Aero LLC · Mansfield, TXS/N 28R-7535216 N1014BClark Joseph C · Avondale, PABuilt 2025 · S/N 42904 N1014QLawler Thomas O · Lava Hot Springs, IDBuilt 1996 · S/N 23029C N1015CCrabtree Chris R · Mooresville, NCBuilt 2020 · S/N STD-FG-565 N1016NDrln Aviation LLC · Charlotte, NCBuilt 2005 · S/N 18281547 N1016XRadial Holdings LLC · Fort Worth, TXBuilt 2000 · S/N 27-0292 N101AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281181 N101AXFogg Britt · Springdale, ARS/N P427 N101BHMpdkm Inc · Las Vegas, NVBuilt 2003 · S/N 01

Back to AD 73-10-02