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.

N29110Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1968 · S/N U206-1080 N29114Grey Goose LLC · Wasilla, AKBuilt 1968 · S/N U206-1084 N2911FRegistration Pending · Fayetteville, ARRegistration pendingBuilt 1966 · S/N 18257011 N2911XRobbins Donald V · Anchorage, AKBuilt 1967 · S/N 17700311 N2911YBennett John M · Cameron, NCBuilt 1962 · S/N 18253911 N29127Shivers William L Jr · Friday Harbor, WABuilt 1968 · S/N U206-1097 N2912SWard Ascher · Oxnard, CAS/N 15066812 N29130Ernst Gregory R · Eagle Creek, ORS/N U206-1100 N2913JMulti Engine Training Co Inc · Tuttle, OKS/N 15065713 N2913SMartin Richard E · Palmyra, WIBuilt 1967 · S/N 15066813 N29142Hall Darryl Wayne II · Wasilla, AKS/N U206-1112 N2914FHarris Zadok · Upland, CABuilt 1965 · S/N 18257014 N2914JMaverick Aviation Holdings LLC · Sheridan, WYS/N 15065714 N29151Inland Aerial Surveys Inc · Riverside, CABuilt 1968 · S/N U206-1121 N2915FStoffregen Thomas S · Milton, WVBuilt 1966 · S/N 18257015 N2915SKoch Kenneth Scott · Coolidge, AZS/N 15066815 N29164Iturriria John · Kuna, IDBuilt 1968 · S/N U206-1133 N2916FAndros Marketing LLC · Fort Lauderdale, FLBuilt 1966 · S/N 18257016 N29173Aerial Transport LLC · Wilmington, DEBuilt 1968 · S/N U206-1140 N2917FBennett David D · Clinton, WABuilt 1966 · S/N 18257017 N2917JKnoll David Alexander · Godwin, NCBuilt 1966 · S/N 15065717 N2917SItz LLC · Lusby, MDBuilt 1967 · S/N 15066817 N29181Wings Of Faith · Stevensville, MTBuilt 1968 · S/N U206-1147 N29186Thoroughbred LLC · Kalispell, MTBuilt 1968 · S/N U206-1151 N29188Rugger Investment Group LLC · Tustin, CABuilt 1968 · S/N U206-1153 N2918JNiemann Benjamin W · Welton, IAS/N 15065718 N2918SAbove All Aviation Inc · Goleta, CABuilt 1967 · S/N 15066818 N2919FPerez Adolfo · Conroe, TXBuilt 1966 · S/N 18257019 N2919SJust Plane Corp · Kokomo, INS/N 15066819 N291KFTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 1972 · S/N 17260482 N29204Jms Aviation LLC · Waynesville, OHS/N U206-1162 N2920JRegistration Pending · Powell Butte, ORRegistration pendingBuilt 1966 · S/N 15065720 N2920SLea Nathanael E · Olalla, WABuilt 1967 · S/N 15066820 N2920YApplegate Susan P · Decatur, TXBuilt 1962 · S/N 18253920 N29210Hawkes Brian R · Hamilton, MTBuilt 1968 · S/N U206-1165 N29217Dawson Adam J · Eveleth, MNBuilt 1968 · S/N U206-1171 N2921JAndrews University · Berrien Springs, MIBuilt 1966 · S/N 15065721 N29221King Management Systems Inc · Liverpool, TXBuilt 1967 · S/N 17700198 N29224Phelan Ricky Ray · Jefferson, ORBuilt 1968 · S/N U206-1176 N2922FKalil Joseph J Jr · Morgan, UTBuilt 1966 · S/N 18257022 N2922JStecklein Brittney R · Overland Park, KSBuilt 1966 · S/N 15065722 N2922SWard Aviation · Marysville, OHBuilt 1967 · S/N 15066822 N2923SHamann John · Orlando, FLBuilt 1967 · S/N 15066823 N2923YS & R Aviation Inc · Boise, IDBuilt 1962 · S/N 18253923 N2924FReese Howard Aviation LLC · Anderson, SCBuilt 1966 · S/N 18257024 N2924JPiscoya Thomas G · Anchorage, AKBuilt 1966 · S/N 15065724 N2924XAllen Thomas L · Cedar Rapids, IABuilt 1967 · S/N 17700324 N2924YLilcad Diversified LLC · Holly Pond, ALBuilt 1962 · S/N 18253924 N2925FRegistered aircraftAssigned, pending cancellationS/N 18257025 N2925SSmolik Amanda · Ponder, TXBuilt 1967 · S/N 15066825

Back to AD 72-03-03 R3