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.

N322DWAutry Michael D · Metuchen, NJBuilt 2015 · S/N 11384N322ERucinski Thomas · Paramus, NJBuilt 1992 · S/N 698-93N322EFRkm Aviation · Lexington, NCBuilt 2021 · S/N 28020031N322EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12782N322ETWing Bird Aviation LLC · Garland, TXBuilt 1975 · S/N TE-1016N322FMeikle Ted S Trustee · Ephraim, UTBuilt 1969 · S/N CE-283N322GEPierce Michael W · Leitchfield, KYS/N 0934N322HAAir Flight Inc · Fort Lauderdale, FLS/N 402C0418N322HCClover Park Technical College · Tacoma, WABuilt 1969 · S/N 28R-31096N322HSReed Systems Ltd · Ellenville, NYBuilt 1974 · S/N D-9709N322HYJk Air LLC · Las Vegas, NVBuilt 2019 · S/N 3322N322JK & M Aviation LLC · West Liberty, KYS/N 24-1316N322JBJ & R Aviation Inc · Sioux Falls, SDBuilt 1990 · S/N E-2549N322JWBravo Aircfraft LLC · Alpharetta, GABuilt 2026 · S/N 172S13521N322KDI Fly High Flight Services LLC · Lovejoy, GABuilt 1973 · S/N 18262285N322KLBuyair LLC · Valdosta, GAS/N 10220N322LKFindley Air LLC · Temecula, CABuilt 1974 · S/N 21060344N322MLAshcraft Aviation LLC · Bay City, TXS/N 3572N322NDUn Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881749N322NHBoyette Thomas E · Parker, COBuilt 1958 · S/N D-5646N322PHCafferty Associates Inc · Sarasota, FLBuilt 1972 · S/N 18261339N322PMMsr Aviation LLC · San Diego, CABuilt 2005 · S/N 29-0365N322QBCaine Timothy · Bend, ORBuilt 1963 · S/N 18254620N322RAEuroamerican Development Group Inc · New York City, NYBuilt 1978 · S/N 13053N322RHRobinson Helicopter Co · Torrance, CABuilt 2026 · S/N 4952N322RMPhillips George Thomas · Carson City, NVBuilt 1981 · S/N 414A0827N322RWKraemer Jeremy A · Melrose, MNBuilt 2000 · S/N 29-0218N322SHelfrick Edward W Jr · Elysburg, PABuilt 1995 · S/N 2005N322SACimarron LLC · Kurten, TXBuilt 1985 · S/N TH-1488N322SCFahey Christopher Scott · Denton, MDBuilt 1960 · S/N CD-274N322SPBurkett Gary L Trustee · Murfreesboro, TNBuilt 1968 · S/N TE-531N322TBBlack Nelson T · Temple, TXBuilt 2010 · S/N 1N322TCUltimate Holdings LLC · Cedar City, UTBuilt 2005 · S/N 10661N322TEEschmann Tim · Novinger, MOBuilt 2004 · S/N 18281372N322TWRegistration Pending · Fairview, NCRegistration pending, pending cancellationBuilt 2002 · S/N 0312N322UWright Gregory A · Strasburg, VABuilt 1966 · S/N CD-1063N322WAAlderman & Company Wings LLC · Danbury, CTBuilt 2004 · S/N 0811N322WBFranco Property LLC · Houston, TXBuilt 2014 · S/N 13765N322WHThurmond Robert Lee · Blessing, TXBuilt 2024 · S/N HC 094N322WRBabineaux Kenneth W · Porter, TXBuilt 1977 · S/N 18266168N322WYBarnette Jerry Jr · Richmond, KYBuilt 2014 · S/N 3222N322ZLafaille David A · Simi Valley, CABuilt 1991 · S/N WP001N32300Primary Flight Control LLC · Fleming Island, FLBuilt 1974 · S/N 28-7515118N32306Legacy Pilot Training LLC · Annandale, MNS/N 28-7515120N3230FRegistered aircraftBuilt 1967 · S/N 670023N3230QArizona Cassidy E · North Platte, NEBuilt 1977 · S/N 28-7790448N3230RAkradi Parviz · Irvine, CABuilt 1987 · S/N CE-1173N3230TLsao LLC · Shelbyville, ILBuilt 1967 · S/N 17700530N3230WHagan Jackson · Wetumpka, ALBuilt 1965 · S/N 32-40N3230YCosta Flying Service Inc · Painted Post, NYS/N 18254230
Back to AD 2007-04-19 R1