OpenAirDocs.org
AD 72-03-03 R3

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
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.

N6868RChrisman Charles Griggs · Denver, COS/N T210-0268N6872FSkybound Aircraft LLC · Blue Point, NYBuilt 1966 · S/N 15063472N6875GStevenson Mark Frank · Anthem, AZBuilt 1970 · S/N 15072375N6876FPalmer Dana G · Gatesville, TXBuilt 1966 · S/N 15063476N6876GMyers Russell E · Happy Jack, AZBuilt 1970 · S/N 15072376N687AZZublin John A III · Murrieta, CABuilt 1968 · S/N 17256592N6882FHernandez Kevin F · Redmond, ORBuilt 1966 · S/N 15063482N6883GSchroeder David C · Norfolk, NEBuilt 1970 · S/N 15072383N6887GMassuet Nancy O · Sunrise, FLBuilt 1970 · S/N 15072387N6889GKozlowski James · Zeeland, MIBuilt 1970 · S/N 15072389N6889RShelton L Wayne · Rifle, COBuilt 1967 · S/N T210-0289N688JFCrothers Travis · Madison, MSBuilt 1968 · S/N 18259510N6891FN6891f LLC · Woodruff, SCBuilt 1966 · S/N 15063491N6892FDent Kelly J · Locust Grove, GABuilt 1966 · S/N 15063492N6892GDetroit Public Schools Community District · Detroit, MIS/N 15072392N6893GHuesgen Paul M · Villa Ridge, MOBuilt 1970 · S/N 15072393N6894FSudduth Robert J · Huachuca City, AZBuilt 1966 · S/N 15063494N6895FFaber Elgin J · Havre, MTBuilt 1966 · S/N 15063495N6896FLandmesser Avis C · Troy, MIBuilt 1966 · S/N 15063496N6897GLewis Derek P · Hurricane, UTBuilt 1970 · S/N 15072397N68AChase William R · Santa Fe, NMBuilt 1963 · S/N 18254837N68AFGunderson Mark H · Reno, NVS/N R172-0283N68FTFat Tire Aviation LLC · New Bern, NCBuilt 1968 · S/N 15068730N68PGNewsom Kevin J · Bloomington, INBuilt 1968 · S/N 15070027N68RAEdwards Richard V · Acampo, CAS/N R172-0119N68VBBeede Curtis M Trustee · Maineville, OHBuilt 1968 · S/N 18259276N68VTAir Positive LLC · Selbyville, DEBuilt 1968 · S/N 18259023N68VVWhite Mark E · Charleston, WVBuilt 1968 · S/N 17700898N68WMHoward Group LLC · Bunnlevel, NCBuilt 1973 · S/N 15074396N6900FIngle Glenn A · Ypsilanti, MIBuilt 1966 · S/N 15063500N6901RFritz Douglas R · Anacortes, WABuilt 1967 · S/N T210-0301N6903GShipe Jacqueline M · Louisville, TNBuilt 1970 · S/N 15072403N6903SSchewe William · Greenville, ILS/N 15067603N6904SKoller Rex E · Athens, ALS/N 15067604N6905SSwanson David L · Rolling Meadows, ILBuilt 1967 · S/N 15067605N6907GMaguire Dennis · Delaware, OHBuilt 1970 · S/N 15072407N6908FFrickel Thomas L · Bristow, NEBuilt 1966 · S/N 15063508N6909FCosgriff Kevin R · Midway, KYS/N 15063509N6909GStemper Peter L · Madison, SDBuilt 1970 · S/N 15072409N6909RMitchell Greg · Pecos, TXBuilt 1967 · S/N T210-0309N690DMGabriel Louis R · Crestview, FLBuilt 1969 · S/N 18259626N690TSMartin Tony A · Kingwood, TXS/N 177RG0384N6910RDirty Birdy Aviation LLC · Silt, COBuilt 1967 · S/N T210-0310N6911FOlson Richard S · Massena, NYBuilt 1966 · S/N 15063511N6911SHodges John Wesley · Chesapeake, VABuilt 1967 · S/N 15067611N6912G98x LLC · Caddo Mills, TXBuilt 1970 · S/N 15072412N6913GAshland Jeffrey C · Spirit Lake, IABuilt 1970 · S/N 15072413N6914FStephens Nicholas J · Santa Rosa, CABuilt 1966 · S/N 15063514N6915FTillison Glenda L · Cameron Park, CABuilt 1966 · S/N 15063515N6915SCochran William J · Williamson, GABuilt 1967 · S/N 15067615
Back to AD 72-03-03 R3