Registered aircraft · 17,027

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:72-03-03-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:72-03-03-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:72-03-03-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:72-03-03-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:72-03-03-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:72-03-03-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.

N2689RMortensen Mark S · Hamilton, MTBuilt 1967 · S/N 18258389 N268DLCrenshaw Robert L · Goldsboro, NCBuilt 1969 · S/N P206-0570 N2690FStephenson Casey H · Assaria, KSBuilt 1965 · S/N 18256790 N2690QSilva Alberto · Titusville, FLBuilt 1970 · S/N 17259104 N2690RSchleck Scott A · West Concord, MNBuilt 1967 · S/N 18258390 N2690XWestern Nebraska Community College · Scottsbluff, NES/N P2060190 N2691QEw Aircraft LLC · Manhattan, MTBuilt 1966 · S/N 18257891 N2691RLongsview Holdings LLC · Lewes, DEBuilt 1967 · S/N 18258391 N2691VHanlon James Bradley Trustee · Fallbrook, CABuilt 1975 · S/N 177RG0658 N2692JDowning Eric D · Saint Charles, MOBuilt 1966 · S/N 15065692 N2692QHill Jonathan Troy · Taylorsville, KYBuilt 1966 · S/N 18257892 N2692ROliver Craig J · Orion, MIBuilt 1967 · S/N 18258392 N2692VKlr Aircraft Sales LLC · Wilmington, DES/N 177RG0659 N2693R15 Rides LLC · Manteo, NCBuilt 1967 · S/N 18258393 N2694QMiller William A Jr · Okeechobee, FLBuilt 1966 · S/N 18257894 N2695LHindberg Jacob W · Fisher, MNBuilt 1967 · S/N 17255895 N2695QKirbco Aviation LLC · Doniphan, MOS/N 18257895 N2695RAccardo Paul A · Zwolle, LABuilt 1967 · S/N 18258395 N2696LPark Rapids Avionics Inc · Park Rapids, MNBuilt 1967 · S/N 17255896 N2696QKlauber Gerald · Lake City, FLBuilt 1966 · S/N 18257896 N2697JSalem Aero Club Inc · Bridgeton, NJBuilt 1966 · S/N 15065697 N2697RMaring Matthew D · Westley, CAS/N 18258397 N2698JKruglov Stephan · Mundelein, ILBuilt 1966 · S/N 15065698 N2698QButler John L · Omak, WABuilt 1966 · S/N 18257898 N2698RWeishaupt Louis R · Mackinaw, ILBuilt 1967 · S/N 18258398 N2699FRegistration Pending · Jonesboro, ARRegistration pendingBuilt 1966 · S/N 18256799 N2699L98x LLC · Caddo Mills, TXBuilt 1967 · S/N 17255899 N2699XAir Controls Billings Inc · Billings, MTBuilt 1966 · S/N P206-0199 N269CJLarson Martin B · Rapid City, SDBuilt 1970 · S/N 17259512 N269RDHumphries Aviation LLC · Maysville, KYS/N 17252737 N26CFKustatan Leasing LLC · Nikiski, AKBuilt 1975 · S/N 20700306 N26GSEaton James Steven · Bristol, RIBuilt 1973 · S/N 15074663 N26LLGmr Leasing LLC · Lincoln, DEBuilt 1966 · S/N 18257595 N26MF2nd Amendment Consulting And Design LLC · Red Bluff, CAS/N 17701425 N26TPGlobal Aerials Inc · Pembroke Pines, FLFirst renewal noticeBuilt 1967 · S/N 17700144 N26ZWeber Mark S · Wildwood, MOBuilt 1969 · S/N 17258153 N2700FRegistration Pending · Hearne, TXRegistration pendingBuilt 1965 · S/N 18256800 N2700LFly First LLC · West Memphis, ARBuilt 1967 · S/N 17255900 N2700PSean Steward Md Pc · Hillsboro, ORS/N 18257803 N2701LRegistration Pending · Los Angeles, CARegistration pendingBuilt 1967 · S/N 17255901 N2701QFraco Air LLC · Vian, OKBuilt 1967 · S/N 18258701 N2701SLeavitt Mark Richard · La Verkin, UTBuilt 1967 · S/N 15066601 N2702FLaird Charles L · Adelanto, CABuilt 1965 · S/N 18256802 N2702QZaenkert Robert C · Okeana, OHS/N 18257902 N2703QEdwards Daniel M · Wendell, NCBuilt 1966 · S/N 18257903 N2703VInman David M · Vancouver, WABuilt 1975 · S/N 177RG0663 N2704FUltimate Aviation LLC · Philadelphia, PABuilt 1965 · S/N 18256804 N2704LAgrifoglio Douglas · Reedley, CABuilt 1967 · S/N 17255904 N2704QWalker Dennis R · Anchorage, AKBuilt 1967 · S/N 18257904 N2704WSpillman David T · Flagstaff, AZBuilt 1967 · S/N U2060690

Back to AD 72-03-03 R3