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.

N2630QParrington Robert · Rifle, COS/N 18257830 N2630RBurdine Kenneth L · Newland, NCS/N 18258330 N2630VAgue Curtis M · Kailua, HIBuilt 1974 · S/N 177RG0636 N2630XBbjc Adventures LLC · Jackson, WIBuilt 1965 · S/N P206-0130 N2631FShepherd Thomas A · Montgomery, NYFirst renewal noticeBuilt 1965 · S/N 18256731 N2631QManning Brian A · Malvern, IABuilt 1966 · S/N 18257831 N2632FOn Final Holdings LLC · West Olive, MIBuilt 1965 · S/N 18256732 N2632LKelley James M · Greenwood, ARBuilt 1967 · S/N 17255832 N2633FYork Greg · Blanco, TXBuilt 1965 · S/N 18256733 N2633RDevries Mark R · Eagle River, AKBuilt 1967 · S/N 18258333 N2634FCockerham Milton D · Gooding, IDBuilt 1965 · S/N 18256734 N2634JCupka Michael J · North Waterboro, MEBuilt 1966 · S/N 15065634 N2634LMetal Mistress Aviation LLC · Meadowview, VABuilt 1967 · S/N 17255834 N2635JWakefield Diep Thao T · Kelseyville, CABuilt 1966 · S/N 15065635 N2635LQueen Matthew E · Shenandoah, VAS/N 17255835 N2635RJong Hoon Cho · Rch Palos Vrd, CABuilt 1967 · S/N 18258335 N2636FCernilia James J · Newport Beach, CABuilt 1965 · S/N 18256736 N2636JScott William B · Owensville, INBuilt 1966 · S/N 15065636 N2637FMccrum James M · Seattle, WABuilt 1965 · S/N 18256737 N2637LAustin Timothy · Abbeville, SCBuilt 1967 · S/N 17255837 N2638LMorgan Todd W · Roscoe, ILBuilt 1967 · S/N 17255838 N2638VWells Larry C · Flowood, MSBuilt 1974 · S/N 177RG0638 N2639FHendershott Kevin J · Vacaville, CABuilt 1965 · S/N 18256739 N2639VBowen Keith S · Lyle, WABuilt 1974 · S/N 177RG0639 N2640VBube Douglas G · Clarkston, WABuilt 1974 · S/N 177RG0640 N2641LTm Aviation Services LLC · Riverside, CABuilt 1967 · S/N 17255841 N2641RHowatt Scott · Hannah, NDBuilt 1967 · S/N 18258341 N2642LRiggin Flight Service Inc · Madison, SDS/N 17255842 N2642QLongerbone Danny L · Fishers, INBuilt 1970 · S/N 17258931 N2643FWortham Bethany S · Soldotna, AKBuilt 1965 · S/N 18256743 N2643QOst Jesse E · Hunter, KSBuilt 1966 · S/N 18257843 N2643RNorthern Wings LLC · Spokane, WABuilt 1967 · S/N 18258343 N2643VGorman Sean P · Superior, COBuilt 1974 · S/N 177RG0641 N2644RColler Randy L · Jackson, MIBuilt 1967 · S/N 18258344 N2645FMichel John Vernon III · Westminster, MDBuilt 1965 · S/N 18256745 N2645LMchugh Eric P · Cleveland, TXS/N 17255845 N2646FAmerican Driveaway LLC · Cowden, ILS/N 18256746 N2647FGayneaux Kelly J · Midland, TXS/N 18256747 N2647JHumble Tony R · Signal Mountain, TNBuilt 1966 · S/N 15065647 N2647LCommonwealth Aviation Services LLC · Herndon, VABuilt 1967 · S/N 17255847 N2647RSaber Wings LLC · Sacramento, CABuilt 1967 · S/N 18258347 N2648FLincoln Sport Parachute Club Inc · Lincoln, NEBuilt 1965 · S/N 18256748 N2648JColonial Air Inc · New Bedford, MABuilt 1966 · S/N 15065648 N2648LZangs William J · Poplar Grove, ILBuilt 1967 · S/N 17255848 N2648QBuck Irrigation Inc · Elkhart, KSBuilt 1966 · S/N 18257848 N2648VWhite Jeffrey W · Macon, GABuilt 1974 · S/N 177RG0642 N2649FSkylane 2649f LLC · Kalispell, MTBuilt 1965 · S/N 18256749 N2649RShah Aitazaz · Shady Shores, TXBuilt 1967 · S/N 18258349 N2649XK-Mcj Equipment LLC · Longview, TXS/N P206-0149 N2650FFlight Time LLC · Highland, MIBuilt 1966 · S/N 18256750

Back to AD 72-03-03 R3