AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-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:2007-04-19-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.

N364MGCw Aviation LLC · Washta, IABuilt 1979 · S/N R18201246N364MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881654N364MSSkyhawk Aviation LLC · Omaha, NEBuilt 1997 · S/N 17280015N364MWUpwind Approach LLC · Lisle, ILS/N E-3651N364SCTfs Inc · Chelsea, ALBuilt 2001 · S/N E-3374N364SLRegistration Pending · Carmel, CARegistration pendingBuilt 1980 · S/N 1011N364SSLampert David M · Atherton, CABuilt 1992 · S/N EA-542N364TJohnsons Ag-Air Inc · Tyler, MNBuilt 1962 · S/N D-7045N364TWVo Thien T · Amarillo, TXBuilt 1985 · S/N EA-449N364VKPetts Adam · Waukee, IABuilt 1981 · S/N E-1973N364WMMoore Bruce W · Aledo, TXBuilt 2014 · S/N 81899N364WPPorter Flying Service · Durham, CAS/N E-1914N364ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881645N3650AMcclain Aviation LLC · Newark, DEBuilt 1969 · S/N D-9077N3650CTotty Michael N · Gainesville, MOBuilt 1954 · S/N 31148N3650RScd Medical LLC · Alexandria, LABuilt 1969 · S/N 28-5747N36511Worley Regenna G · Ellijay, GABuilt 1978 · S/N 28-7890520N3651CHately William · Anchorage, AKBuilt 1978 · S/N R18200295N3651UDeibel Adam · Flagstaff, AZS/N 18255051N3651WTraxler Christopher V · Russia, OHBuilt 1966 · S/N 32-556N3651ZCrabtree Glenn E · Guthrie, OKBuilt 1960 · S/N 22-7548N3652QNolen David S · Wimberley, TXBuilt 1967 · S/N MA-239N3652RShales Rene J · Hampshire, ILBuilt 1969 · S/N 28-5756N3652WValiair Limited Co Trustee · Casper, WYS/N 32-557N3652YMokhtari Rasoul · Nashville, TNBuilt 1963 · S/N 21058152N3653AKlemenhagen David · Wasilla, AKBuilt 1969 · S/N TC-1309N3653CDomingquez Clara · Anchorage, AKBuilt 1954 · S/N 31151N3653NBurch Herbert K · Milan, OHBuilt 1967 · S/N 680025N3653PWright Michael · Hurricane, UTS/N 22-3404N3653QFlying Naked Muskteers LLC · Palm City, FLBuilt 1967 · S/N MA-240N3653RSingh Harsimran · Las Vegas, NVBuilt 1970 · S/N 28-5758N3653UMedeiros Germano Manuel · Caruthers, CABuilt 1963 · S/N 18255053N3653ZMandibles Edward Jr · Lompoc, CABuilt 1960 · S/N 22-7550N36541Plains Aviation · Mitchell, SDBuilt 1978 · S/N 28-7890521N36546Lighthouse Drones LLC · New Smyrna Beach, FLBuilt 1978 · S/N 32R-7885193N3654CRose Hugh S · Fairbanks, AKBuilt 1954 · S/N 31152N3654KBeaber Michael J · Fremont, OHBuilt 1967 · S/N 28-23673N3654RSierra Delta 1 LLC · Dover, DEBuilt 1969 · S/N 28-5759N36555Smith Jeffrey D · Murrells Inlet, SCBuilt 1978 · S/N 32R-7885194N3655CViavant Toby S · Ester, AKBuilt 1954 · S/N 31153N3655NPeterson Jesse D · Wasilla, AKBuilt 1947 · S/N 12-1906N3655UBoggs Dennis E · Buffalo, WYBuilt 1963 · S/N 18255055N36563Ware Richard A · Versailles, OHBuilt 1978 · S/N 28-7890513N36565Maxwell James B · Lewiston, IDBuilt 1968 · S/N TC-1142N36567Kempton Larry G Jr · Grand Junction, COBuilt 1978 · S/N 28-7890522N3656PKennedy Lukas · Anchorage, AKS/N 22-3407N3656UMccarty Troy Allen · New Plymouth, IDBuilt 1963 · S/N 18255056N3656WNuvision Heaqlth Center · Macomb, MIBuilt 1966 · S/N 32-562N36574California In Nice Inc · San Jose, CABuilt 1978 · S/N 28R-7837284N36575Brill Charles F · Spring, TXBuilt 1978 · S/N 32R-7885195
Back to AD 2007-04-19 R1