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.

N16128Marquette County Flying Club · Marquette, MIBuilt 1972 · S/N 15073497N16129Rankin Kevin · Maryville, MOBuilt 1972 · S/N 15073498N16134Adibi Saeed · Huntsville, ALBuilt 1976 · S/N 17702485N16137Hines Roger E · Greenville, OHBuilt 1976 · S/N 17702487N1613FAde William Henry III Trustee · Tucson, AZBuilt 1966 · S/N 17255008N1613HHampton William R · Marietta, GAFirst renewal noticeBuilt 1975 · S/N 177RG0786N1614FMathena Chad R · Narrows, VABuilt 1966 · S/N 17255009N1615FWells Edmund B · Austin, MNBuilt 1966 · S/N 17255010N16165Registered aircraftBuilt 1972 · S/N 15073514N16166Hayden Scott M · Walworth, WIBuilt 1972 · S/N 15073515N16169Trotter Patrick J · North Las Vegas, NVBuilt 1972 · S/N 15073518N1616FMarciel John L · John Day, ORBuilt 1966 · S/N 17255011N1616HMayworm Jeffrey A · Ocala, FLBuilt 1975 · S/N 177RG0789N1616QKrehbiel Bradley C · Lake City, MNS/N 15072916N16174Cirrostrats Inc · Deland, FLBuilt 1972 · S/N 15073523N16177Norby Aviation LLC · Hopkinton, MABuilt 1972 · S/N 15073525N16179Farrell Donald A · Owasso, OKBuilt 1972 · S/N 15073527N1617HFlying Cloud Cherokees Inc · Chanhassen, MNBuilt 1975 · S/N 177RG0790N1617QAljanabi Mohammed Khalid · Herndon, VAS/N 15072917N16180Last Mango Air LLC · Fond Du Lac, WIBuilt 1972 · S/N 15073528N16184Finkel David M · Shelbyville, INS/N 15073530N16185Schwartz David W · Windsor, NYBuilt 1976 · S/N 17702491N1618FCastillo Giovanny G · Brodheadsville, PAS/N 17255013N1618HMemrick Paul · Cedar Park, TXBuilt 1975 · S/N 177RG0791N16194Booth Jesse R · Alamosa, COBuilt 1972 · S/N 15073537N16196Macdonald Kaitlyn A · Dillon, MTBuilt 1972 · S/N 15073539N16199Allbritton John Mark Trustee · Oakland, TNBuilt 1976 · S/N 17702493N1619FReeve Howard E · Minot, NDS/N 17255014N1619QAmos Carl R · Chandler, INBuilt 1971 · S/N 15072919N16202Steward Charles M · Tuttle, OKS/N 15073543N16206Schultz Aviation Services LLC · Crowley, LABuilt 1972 · S/N 15073544N16207Martinez Jose Antonio · Orlando, FLBuilt 1972 · S/N 15073545N16210Simpson Dean H · Limon, COBuilt 1972 · S/N 15073546N16216Scott Jeffrey A · Camden, TNBuilt 1972 · S/N 15073549N1621FDimtroff John P · Issaquah, WABuilt 1966 · S/N 17255016N1621HDavis Vance · Del Valle, TXS/N 177RG0794N16221Aero Maintenance Inc · Vancouver, WABuilt 1972 · S/N 15073553N16222Thumser Douglas Francis · Newcastle, CABuilt 1972 · S/N 15073554N16223Flyhnz LLC · Oxford, NCS/N 15073555N16225Tumminaro Michael · Neodesha, KSBuilt 1972 · S/N 15073557N1622FN1622f LLC · Grand Prairie, TXBuilt 1966 · S/N 17255017N1622HSweeney Kay M · Kirkland, WABuilt 1975 · S/N 177RG0795N1622QSchweim Robert J · Ocean City, NJBuilt 1971 · S/N 15072922N16238Hayes Lance Garett · Opelousas, LABuilt 1972 · S/N 15073564N1623FVilvens Justin T · Granville, OHS/N 17255018N1623QHigh Exposure Inc · Wilmington, DES/N 15072923N16243Como Jerry Wayne · Murfreesboro, TNBuilt 1972 · S/N 15073567N1624FPruitt Leonard E · The Colony, TXBuilt 1966 · S/N 17255019N1625QRegistration Pending · Powell, TNRegistration pendingS/N 15072925N1626FDelgadillo Jose M · League City, TXBuilt 1966 · S/N 17255021
Back to AD 72-03-03 R3