OpenAirDocs.org
AD 72-14-08 R1

Registered aircraft · 1,578

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-14-08-R1')
    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-14-08-R1')
  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.

N3304XPhillips Daniel J · Argusville, NDBuilt 1967 · S/N 310L-0154N3307XMathison John M · Vancouver, WABuilt 1967 · S/N 310L-0157N3308QDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 320D0108N3309QB & R Aerial Crop Care Inc · Connell, WABuilt 1966 · S/N 320D0109N3309XCabanas Alexis Santiago · Stroudsburg, PAS/N 310L-0159N3310DGrewe Mike · Lake In The Hills, ILBuilt 1972 · S/N 310Q-0630N3313XBowman Cody · Brooklyn, MIBuilt 1967 · S/N 310L-0163N3314XGalloway James D · Whitmore Lake, MIS/N 310L0164N3315QTcf Ventures LLC · Wilmington, DEBuilt 1966 · S/N 320D0115N3315XElberg Paul · Aventura, FLBuilt 1967 · S/N 310L0165N3316QPerson Michael · West Chester, PABuilt 1966 · S/N 320D0116N3317QSkynight 17q LLC · Roseville, CABuilt 1966 · S/N 320D0117N3318Q2400 Rickenbacker LLC DBA · Auburn, CABuilt 1966 · S/N 320D0118N3319QNeuschaefer George H · White Hills, AZBuilt 1966 · S/N 320D0119N331BXFay Craig J · Fairfax Station, VABuilt 1967 · S/N 310L-0168N331LSTechnical Education Services Inc · Virginia Beach, VABuilt 1969 · S/N 310Q0028N3321XPatton Aviation LLC · Billings, MTS/N 310L-0171N3325QWinrick LLC · Flagstaff, AZS/N 320D0125N3327XTrimble Anthony W · Weatherford, TXBuilt 1967 · S/N 310L-0177N3330XMylin LLC · Havre De Grace, MDS/N 310L-0180N3335XPfeiffer Engineering LLC · Boonville, MOBuilt 1967 · S/N 310L-0185N3339XWestfall Michael T · Woodstock, GABuilt 1967 · S/N 310L-0189N333CJDrj Aviation LLC · Dover, DEBuilt 1972 · S/N 421B0313N333ESRebus LLC · Andover, KSS/N 310Q0232N333JCHunter Prim LLC · Bolingbroke, GABuilt 1967 · S/N 310L-0197N333KWD G R Air LLC · Braselton, GABuilt 1974 · S/N 421B0657N333SFFerretti James L III · Port Orange, FLBuilt 1967 · S/N 411-0260N333WDWoelbing Aviation LLC · Franksville, WIBuilt 1966 · S/N 310L-0002N3340XVito Bavaro Construction Inc · Escalon, CAS/N 310L-0190N3341XJackson Rex A · Granbury, TXBuilt 1967 · S/N 310L-0191N3345XTurel Gary J · Tigard, ORS/N 310L-0195N3354QOn The Beam Aviation Inc · Hampton, GABuilt 1967 · S/N 310L-0204N3355QSunshine Aircraft Repair Inc · Lindenhurst, ILS/N 310L-0205N3364LLopez Edwin · Germantown, TNS/N 310Q0784N3377QMendez Jr Leo · Corpus Christi, TXS/N 421B0261N337PLMaglaughlin Ronald D · Udall, KSBuilt 1969 · S/N 402A0039N3398QRiebe Grover C Jr · Gwinner, NDBuilt 1969 · S/N 421A0108N33UPAero Valley Properties LLC · Roanoke, TXBuilt 1961 · S/N 320-0078N33VTTjr Aviation LLC · Orefield, PAS/N 310Q0974N3405QHardin David A · Tukwila, WABuilt 1966 · S/N 320E-0005N3412QPoulsen Melvin J · Orem, UTS/N 320E0012N3417QGholami Amir H · Santa Rosa, CABuilt 1966 · S/N 320E0017N3437QJamerson Kendall L · Bovina, TXBuilt 1966 · S/N 320E0037N3444QKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1966 · S/N 320E0044N344JPCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 35713N3452QGolden Arrow Transportation Co · Plainfield, NJBuilt 1966 · S/N 320E-0052N3457BChase Dennis A · Naperville, ILBuilt 1955 · S/N 35032N3458QIngram John · Los Angeles, CABuilt 1966 · S/N 320E-0058N3474QLyle Timothy · Lakewood Ranch, FLBuilt 1966 · S/N 320E-0074N3478QCsc Aviation LLC · Parker, COS/N 320E-0078
Back to AD 72-14-08 R1