OpenAirDocs.org
AD 72-03-03 R3

Registered aircraft · 17,028

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.

N8663GLake George Aviation LLC · Warwick, NYBuilt 1966 · S/N 15062763N8663USocks Flyers LLC · Southgate, KYS/N 17252566N8664SMansuroff Eugene E · Carteret, NJBuilt 1965 · S/N 15061964N8665URathbun Kendrick C · Ocala, FLBuilt 1965 · S/N 17252568N8666USchultz Mark S · Mokena, ILBuilt 1965 · S/N 17252569N8667UHillier Ian P · Hummelstown, PABuilt 1965 · S/N 17252570N8668GClosson Luke E Jr · Valdosta, GABuilt 1966 · S/N 15062768N8668SCooper Jerry A · Kennewick, WAS/N 15061968N8668UGragg Michael W · Newland, NCS/N 17252571N8670SFlying Hawks Ranch LLC · Bruning, NEBuilt 1965 · S/N 15061970N8670USkyhawk Aviation LLC · Oskaloosa, IAS/N 17252573N8671JFarrar Kelley J · Ames, IABuilt 1967 · S/N 15066571N8672JHunt Daniel · Hayward, CABuilt 1967 · S/N 15066572N8672SAres Aviation LLC · Holly Ridge, NCBuilt 1965 · S/N 15061972N8672UEcho Tango LLC · Milledgeville, GABuilt 1965 · S/N 17252575N8673JAdams Dirk L · Pleasant Hill, OHBuilt 1967 · S/N 15066573N8673UCarpenter Alan B · Wasilla, AKBuilt 1965 · S/N 17252576N8674UAngle Kevin D · Rocky Mount, VAS/N 17252577N8674ZHoch Lance M · Weiser, IDBuilt 1968 · S/N P206-0474N8677SClay Robert W · Hancock, MNBuilt 1965 · S/N 15061977N8677UHunter Richard Louis · Wilton, CABuilt 1965 · S/N 17252580N8678JIvanchenkov Alexandr N · Arden, NCBuilt 1967 · S/N 15066578N8678URoane Aaron J · Ogden, UTBuilt 1965 · S/N 17252581N8679ULake Aera Technical College · Watertown, SDBuilt 1965 · S/N 17252582N8680SMaestro Aviation LLC · Anson, TXBuilt 1965 · S/N 15061980N8680URoberts Robert V · Sebastian, FLBuilt 1965 · S/N 17252583N8681GGrammer Samuel C · Vernal, UTBuilt 1966 · S/N 15062781N8681JSaitto Jeffrey M · Media, PABuilt 1967 · S/N 15066581N8681UFly Around Alaska LLC · Palmer, AKS/N 17252584N8682UAircraft N8682u Inc · Half Moon Bay, CABuilt 1965 · S/N 17252585N8683UConrad Richard M · Chinook, MTBuilt 1965 · S/N 17252586N8684GTorres Andres · Plano, TXBuilt 1966 · S/N 15062784N8684UOlsovsky Jesse C · Bonita Springs, FLBuilt 1965 · S/N 17252587N8686SKaines John L · Ludington, MIBuilt 1965 · S/N 15061986N8687GLindsey John Monroe · Dover, ARBuilt 1966 · S/N 15062787N8687JManthey Daniel T · Marine St Crx, MNBuilt 1967 · S/N 15066587N8688SKubik Darrel J · Boise, IDBuilt 1965 · S/N 15061988N8688USabol Andrew R · Waterville, NYBuilt 1965 · S/N 17252592N8688ZPowell Leo · Villa Park, CAS/N P206-0488N868LBPatriot Leasing LLC · Abilene, TXBuilt 1969 · S/N 18259911N8690SSandy River Flying Club · Phillips, MEBuilt 1965 · S/N 15061990N8691GWings Over Texas Holdings LLC · Denton, TXBuilt 1966 · S/N 15062791N8691SBonner John A III · Ocala, FLBuilt 1965 · S/N 15061991N8692SRobinson Deon D · Mesquite, TXBuilt 1965 · S/N 15061992N8693UCone Randall D · Salida, COBuilt 1965 · S/N 17252597N8695JN8695j LLC · Buckeye, AZS/N 15066595N8696SBartel Duane M · Ocean Shores, WAS/N 15061996N8697GAeronautical Technical Service Inc · Collierville, TNS/N 15062797N8698GPriddle Kody W · Norfolk, VABuilt 1966 · S/N 15062798N8698JWaddey Caleb M · Cottage Grove, TNBuilt 1967 · S/N 15066598
Back to AD 72-03-03 R3