OpenAirDocs.org
AD 2018-03-03 R1

Registered aircraft · 1,770

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:2018-03-03-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:2018-03-03-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.

N37424Flight Development LLC · Wichita, KSS/N 421C0658N37475N37475 Management LLC · Las Vegas, NVBuilt 1977 · S/N 421C0412N37478Ghareeb Enterprises Inc · Charleston, WVS/N 421C0415N3747CS I Air Inc · Dover, DEBuilt 1975 · S/N 414-0818N3752CMiller Robert G · Clear Lake, IAS/N 414-0819N37543Construction Solutions & Consulting LLC · Sedalia, MOS/N 414A0002N3758CDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 414-0839N375KCGuittard Chocolate Holdings Co · Burlingame, CABuilt 1982 · S/N 421C1226N375RHyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0468N37676Campbell & Associates Investment Properties LLC · Burleson, TXBuilt 1974 · S/N 421B0584N377GLDodson International Parts Inc · Rantoul, KSS/N 425-0233N377JMSanchez Joshua A · Bosque, NMBuilt 1976 · S/N 421C0221N378KAga Aviation LLC · Lewes, DES/N 421C0499N3796CPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1974 · S/N 402B0803N379TWTanglewood Aviation LLC · Fort Mill, SCBuilt 1981 · S/N 414A-0616N37FSLuxury Transportation LLC · Talladega, ALS/N 414A0830N37JKSsr LLC · Incline Village, NVS/N 421B0934N37MBresciani Martin · Guaynabo, PRS/N 421B0805N37PSOldenbroek Cornelus Trustee · Medina, TXBuilt 1981 · S/N 425-0050N37RZOwens Martin · Telluride, COBuilt 1979 · S/N 421C0823N37UJet Set Aircraft Inc · Van Nuys, CABuilt 1977 · S/N 414A0010N382BWWd Aviation Group Inc · Atlanta, GAS/N 421C0711N382MCShiver James B · Stanley, NMS/N 421B0452N384AMHaggard Haley G · Springer, OKS/N 421B0304N385CAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0111N38CJAirplane Seven LLC · Watkins, COBuilt 1978 · S/N 402C0023N38GJMonahan Jeffrey L Trustee · Long Beach, CABuilt 1982 · S/N 414A0829N38LPN38lp LLC · Jacksonville, FLBuilt 1977 · S/N 414-0960N3908CMccreery Aviation Co Inc · Mcallen, TXBuilt 1976 · S/N 421C0136N3920CN3920c Lc · Wichita, KSBuilt 1976 · S/N 421C0145N3922CN3922c LLC · Dover, DEBuilt 1977 · S/N 421C0419N3923CSwope Aviation LLC · Elizabethtown, KYBuilt 1976 · S/N 421C0147N393MPDutch Indian Air LLC · Riverdale, CABuilt 1976 · S/N 421C0203N3968GWatkins Aviation LLC · Golden Valley, MNBuilt 1977 · S/N 421C0422N39ACalifornia-Oregon Development LLC · Portland, ORS/N 425-0138N39HCTherapy Air LLC · Midland, TXS/N 414-0469N39WHGolden Touch LLC · Kalispell, MTBuilt 1976 · S/N 421C0070N3DJHatch Hyrum G · Chandler, AZS/N 421C0011N3DQCrescent Aviation LLC · Rllng Hls Est, CABuilt 1970 · S/N 414-0056N3KXMarathon California Holdings Lp · San Diego, CABuilt 1971 · S/N 414-0161N3VACook Marvin R · Portales, NMS/N 414-0258N3WFFolk Wolfgang · Fairfield, CABuilt 1975 · S/N 414-0617N400ATAlpha Tango Aviation Inc · Middletown, DEBuilt 1981 · S/N 402C0510N400BJAirrich LLC · Largo, FLBuilt 1974 · S/N 421B0819N400BSMb Aviation Inc · Larue, TXS/N 421C1089N400CEMcmurray Bradley Thomas · Advance, NCBuilt 1975 · S/N 421B0930N400EWWilliams J David · Kerrville, TXBuilt 1981 · S/N 425-0095N400FCCrosswind Enterprises LLC · Box Elder, SDS/N 414A0023N400TMPaxton Homes LLC · Killeen, TXS/N 421B0885N401AKKulon Andrew · Wyanet, ILS/N 401A0090
Back to AD 2018-03-03 R1