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.

N42161Registered aircraftS/N 28-7425312N42164Bush David W · Camden, NCBuilt 1968 · S/N 18258882N42167Howarth Jason A · Lancaster, PABuilt 1974 · S/N 28-7415383N42168Registration Pending · Denton, TXRegistration pendingBuilt 1974 · S/N 28-7415384N4216QFoulkrod Freebird LLC · Buda, TXBuilt 1975 · S/N U20603040N4216TExtreme Metals LLC · El Dorado, ARBuilt 1971 · S/N 28-7205102N4216YTusquittee Flyers Aero Club LLC · Hayesville, NCS/N 345-77N4216ZGleason Egan · Valdez, AKBuilt 1966 · S/N 18-8437N42175Roberts Jason L · Crossville, TNBuilt 1968 · S/N 18258885N42176N42176 LLC · Lynn Haven, FLBuilt 1968 · S/N 18258886N42177Skydive Baltimore LLC · Churchville, MDBuilt 1968 · S/N 18258887N4217JShuffler David · Kingman, AZBuilt 1966 · S/N 28-22565N4217PInternational Air Services Inc Trustee · Carson City, NVS/N 23-1710N4217TBentzen David A · Deer Park, WABuilt 1968 · S/N 28R-30975N4217ZSchock Erik D · Wasilla, AKBuilt 1974 · S/N 18-7409043N42182Schaible John F · Palmerton, PABuilt 1973 · S/N 18052323N42184Designed Cabinets · Lakeville, MNBuilt 1968 · S/N 18258890N42188Verge Gregory J · Lynnwood, WABuilt 1968 · S/N 18258891N4218ARed Skye 52 LLC · Port Orange, FLS/N 52-8271AN4218HGenna Aviation LLC · Newfield, NJBuilt 1978 · S/N 24-0665N4218KParker Helicopters Inc · Watsonville, CABuilt 2009 · S/N 12645N4218PPn4 Aviation Holdings LLC · Bishop, CAS/N 23-1711N4218QSavant John D · Kinder, LAS/N 17260118N4218TGolden Pick LLC · Maple Plain, MNS/N 28-7225096N4218YDaniels David R · El Paso, TXBuilt 1955 · S/N 18-2510N42198Johnson Steve · Belen, NMBuilt 1968 · S/N 18258894N4219HHardman Lorin D · Wasilla, AKBuilt 1948 · S/N 14-22N4219QAudrain Flying Club Inc · Mexico, MOS/N 17260119N4219ZBubber Inc · Lake Providence, LABuilt 1966 · S/N 18-8442N421AGone Flyin LLC · Wilmington, DEBuilt 1981 · S/N 421C1211N421ACCroft Dennis W · Spencerville, OHBuilt 1966 · S/N 1066N421AKMcgregor Grant · Chugiak, AKBuilt 2023 · S/N 001N421BJRegistered aircraftBuilt 1968 · S/N TC-1057N421BSSell Robert O · Prescott Valley, AZBuilt 2004 · S/N 90247N421BTJolley Robert W · Comanche, TXBuilt 2001 · S/N 23786N421CShadow Cat Aviation LLC · Fitchburg, WIBuilt 2002 · S/N 0434N421CSCrowbar Enterprises LLC · Inola, OKBuilt 2021 · S/N 18283121N421CVRed-Tailed Hawks Aviation Academy Inc · Mukilteo, WABuilt 1979 · S/N 17272437N421DLLaplant James R · Newton, IABuilt 1974 · S/N 28-7415326N421DNDel Mar College · Corpus Christi, TXBuilt 1968 · S/N 421-0146N421ERCc Aviation Inc · Tracy, CABuilt 2004 · S/N 172S9679N421FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2004 · S/N 18281495N421HSQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N 421C0621N421JAJohnson Michael K · Alpine, WYBuilt 2008 · S/N 3027N421LJAaces Flight Operation LLC · Ellisville, MOBuilt 2010 · S/N 1095-2010N421MJLevine Jonathan L · Waterford, CTBuilt 2000 · S/N 2843338N421NMWings Over The Rockies Air & Space Museum · Denver, COBuilt 1961 · S/N G-720N421PTRozneck Paul E · Edmond, OKBuilt 2006 · S/N 22487N421PWMead Lawrence C Trustee · Powell, OHBuilt 2002 · S/N E-3466N421RWPac1 LLC · Clinton, IABuilt 2004 · S/N 172S9593
Back to AD 2007-04-19 R1