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.

N2783FVspp Consulting LLC · Stevensville, MDBuilt 1966 · S/N 18256883N2784SThomas Michael R · Marshall, MOS/N 15066684N2785FAugustin Lyn H · Saint Thomas, NDBuilt 1966 · S/N 18256885N2786FChristoph Nicolas T · Okanogan, WABuilt 1966 · S/N 18256886N2787FWammen Gil V · Reva, SDBuilt 1966 · S/N 18256887N2787LGateway Flying Club Inc · Saint Louis, MOBuilt 1967 · S/N 17255987N2787QThorell Farms Inc · Loomis, NES/N 18257987N2788FShryock Patrick D · King Salmon, AKS/N 18256888N2788QKahle Matthew N · Paw Paw, MIBuilt 1967 · S/N 18257988N2789LChurch Sammy H · Statesville, NCBuilt 1967 · S/N 17255989N2789QCenterline LLC · Yankton, SDBuilt 1967 · S/N 18257989N278BDStubbs J Phillip · Richmond, VABuilt 1967 · S/N 17255945N278SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 177RG0571N2790LWells Mark L · Eads, TNBuilt 1967 · S/N 17255990N2790QArthur Lloyd T · Greenfield, INS/N 18257990N2792FRoshong Loman · Leesville, LABuilt 1966 · S/N 18256892N2792QPalmer Paul F · Donnelly, IDBuilt 1967 · S/N 18257992N2794QVincer Way LLC · Centennial, COBuilt 1967 · S/N 18257994N2795FRegistration Pending · Marietta, GARegistration pendingBuilt 1966 · S/N 18256895N2795LHarkness Paul E · Richmond Hill, GABuilt 1967 · S/N 17255995N2796FX-Ray Engineering Corp · Port Orange, FLS/N 18256896N2796LSmyth Michael L · Saint Charles, MOBuilt 1967 · S/N 17255996N2797FWhatley Charles J · Goliad, TXBuilt 1965 · S/N 18256897N279CMMckenzie Robert A · Downers Grove, ILBuilt 1969 · S/N 18259822N27FCWalburn John M · Mansfield, OHBuilt 1962 · S/N 18254410N27JSSmith Cattle Company LLC · Steamboat Rock, IABuilt 1974 · S/N 177RG0629N27JWGaither William W · Shallotte, NCS/N 17701148N27TDMenor Michael D · Menominee, MIBuilt 1966 · S/N 15065577N27WDDrummond Jonathan B · Curtice, OHBuilt 1963 · S/N 205-0376N2800FMeyer Scott R · Palm Harbor, FLBuilt 1966 · S/N 18256900N2800LGarcia Fernando · Laredo, TXBuilt 1967 · S/N 17256000N2800SSimpson Gavin J · Medford, ORBuilt 1967 · S/N 15066700N2800YCherokee 92t LLC · Polk, OHBuilt 1962 · S/N 18253800N2801SLavere Paul · Adams, NYBuilt 1967 · S/N 15066701N2801XJones Daniel L · Newton, ALBuilt 1967 · S/N 17700201N2802FC-All Mfg Inc · Atoka, OKBuilt 1966 · S/N 18256902N2802QPrecision Management LLC · Bossier City, LABuilt 1962 · S/N 18254034N2802SBurt Charley R · Anchorage, AKBuilt 1967 · S/N 15066702N2803XStamper Douglas H · Norfolk, VABuilt 1967 · S/N 17700203N2803YDakota Aircare Inc · Wagner, SDS/N 18253803N2804FChristensen David W · Lyman, UTBuilt 1966 · S/N 18256904N2804RBarnhill Gregory L · Leawood, KSBuilt 1967 · S/N 18258404N2804SAlmy David W · Riverside, CABuilt 1967 · S/N 15066704N2804YLyons Brian E · Cortez, COBuilt 1962 · S/N 18253804N2805QA L Hollandsworth LLC · Columbia, MOBuilt 1971 · S/N 17259805N2806QLawson Lance J · Sikeston, MOBuilt 1971 · S/N 17259806N2806YPautler Justin H · Alden, NYBuilt 1962 · S/N 18253806N2807LBerisha James · Porter, TXS/N 17256007N2807QReynolds David F · Port Orange, FLBuilt 1971 · S/N 17259807N2808RInman Matthew · Gallatin, TNBuilt 1967 · S/N 18258408
Back to AD 72-03-03 R3