OpenAirDocs.org
AD 72-03-03 R3

Registered aircraft · 17,023

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.

N11899Mccrigler Luke N · Fortuna, CABuilt 1974 · S/N 15075696N11906Rodriguez Jose · Los Angeles, CABuilt 1974 · S/N 15075701N11907Housatonic Flying Club Inc · Danbury, CTBuilt 1975 · S/N 17702380N11909Weaver Craig A · Pickerington, OHBuilt 1974 · S/N 15075703N1190FDonnelly Patrick J · Tupper Lake, NYBuilt 1966 · S/N 17254785N1190MDorr Daniel B · Locust Grove, GABuilt 1969 · S/N 17258690N11910Destefano Dennis C · New Port Richey, FLS/N 15075704N11913Sharkey Peter T · Providence, RIBuilt 1974 · S/N 15075706N1191CZerfas Gary B · Rockwall, TXBuilt 1977 · S/N 17702684N1191FStopa Gary · Florida, NYBuilt 1966 · S/N 17254786N1191MMoore John S · Tracy, CABuilt 1969 · S/N 17258691N11927Omlid Robert · Watford City, NDBuilt 1974 · S/N 15075712N1192MGaruda Aviation Inc · Miami, FLBuilt 1969 · S/N 17258692N11935Legacy Pilot Training LLC · Annandale, MNBuilt 1974 · S/N 15075713N11936West Yayoi M · Sonoma, CABuilt 1974 · S/N 15075714N11937Rdt Aviation LLC · Trumbull, CTS/N 17702381N11938Johnson William L · Middleburg, VABuilt 1974 · S/N 15075716N1193MEagle Sky Patrol Inc · Deadwood, SDBuilt 1969 · S/N 17258693N11940Elkeberry Morgan T · Sycamore, OHBuilt 1974 · S/N 15075718N11942Puls Kurt V · Valparaiso, INS/N 15075720N11944Weed Ellen M · Gassaway, WVBuilt 1974 · S/N 15075722N11946Solari Michael R · Gilroy, CABuilt 1974 · S/N 15075724N1194MGadamic LLC · Fresno, CABuilt 1969 · S/N 17258694N11950Plenkers Russell A · Molino, FLBuilt 1975 · S/N 17702382N11952Jones William Edward · Scottsdale, AZBuilt 1974 · S/N 15075730N11953Sanchez Chayanne R · Apex, NCBuilt 1974 · S/N 15075731N11957Kopecky Dawn D · Center, NDBuilt 1974 · S/N 15075735N11959Quyser Adil · Edison, NJBuilt 1974 · S/N 15075737N11962Aeroleasing Inc · Medford, ORBuilt 1974 · S/N 15075740N11968Good Guys Finish First Inc · Colorado Springs, COS/N 17702383N11970Kiforishin Samuel · Westfield, MAS/N 15075748N11971Registration Pending · Durham, NCRegistration pendingBuilt 1974 · S/N 15075749N11974Yilmaz Enes A · Austin, TXBuilt 1974 · S/N 15075752N1198FStockle Barry W · Oakland, CABuilt 1966 · S/N 17254793N1198MGoeke Christine A Trustee · Hartland, WIBuilt 1969 · S/N 17258698N119MSAeronorth LLC · Ann Arbor, MIBuilt 1969 · S/N 21059121N11BTBravo Tango LLC · Minden, LABuilt 1965 · S/N 18256146N11DZLowe Jacob · Knoxville, TNBuilt 1965 · S/N 18256245N11FNScheck Christopher R · Troutdale, ORBuilt 1973 · S/N 15074423N11JTJjj Ventures LLC · Bronx, NYBuilt 1969 · S/N 15071181N11LATwo-Ten LLC · Ramona, CABuilt 1968 · S/N 21059058N11YSBonanza N5745v LLC · Colorado Springs, COBuilt 1968 · S/N 15068608N11YWBaldwin William E · Kula, HIBuilt 1970 · S/N 15072351N11YZHuggins David R · Carmichael, CABuilt 1970 · S/N 18260401N12000Bear Creek Air LLC · Helena, MTBuilt 1968 · S/N 18259487N1200GHartmann Kaiser Robert · New York, NYBuilt 1972 · S/N 15073901N1203CMirzaei-Nejad Hamid · Lake Stevens, WAS/N 17702685N1203QMusick John Thomas · White Hall, ARBuilt 1971 · S/N 15072503N1205BEngel Shane J · Willow, AKBuilt 1963 · S/N 205-0190N1205CNorthern Aire Flying Club Ltd · Black Creek, WIBuilt 1977 · S/N 17702686
Back to AD 72-03-03 R3