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.

N4083A4083a LLC · Wilmington, DES/N D-9110N4083DAerohawk Aviation Inc · Idaho Falls, IDBuilt 1957 · S/N 34783N4083EHulsey Steven M · Chugiak, AKBuilt 1977 · S/N 18-7809056N4083XKnutson Wayne R · Thompson, NDBuilt 1971 · S/N 5183N4083ZRaymond Raphael T · Helix, ORBuilt 1964 · S/N 18-8098N4084Dailey Garrett C · Alamo, CABuilt 1960 · S/N BG-391N40842Avz Aviation Inc · Knoxville, TNBuilt 1973 · S/N 28-7415094N40845Rich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1973 · S/N 28-7405070N4084EIngham Ben B · Sonora, TXS/N 18-7809058N4084SDavenport Michael · Naperville, ILBuilt 1975 · S/N D-9729N4084TEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1863N4084WGraham Jessami T · Walsh, COBuilt 1966 · S/N 32-40133N4084ZHull Keath C · Wasilla, AKFirst renewal noticeBuilt 1964 · S/N 18-8099N40850Mitchell Timothy · Enterprise, ALBuilt 1973 · S/N 28-7425178N40852Air Performance LLC · Kalispell, MTBuilt 1973 · S/N 28R-7435134N40855Covey Stephen B · Manvel, TXBuilt 2000 · S/N E-3298N40856Griggs Gerald A · Blairsville, GABuilt 1973 · S/N 28-7425180N40857Muller-Levan Christina J · Kempton, PABuilt 1973 · S/N 28-7415099N40858Dicey Aviation LLC · Somerset, KYBuilt 1973 · S/N 28-7415102N4085BMarroquin Jesse B DBA · Schertz, TXFirst renewal noticeBuilt 1976 · S/N 76-30821N4085EGrass Roots Flying Inc Trustee · Wilmington, DEBuilt 1978 · S/N 18-7809059N4085PTango Bravo Aviation LLC · Taylorsville, MSBuilt 1959 · S/N 23-1563N4085WIrvin Gary Z · Parrish, FLFirst renewal noticeBuilt 2001 · S/N 25190N40862Ratliff William Thomas III · Knoxville, TNBuilt 1973 · S/N 28-7405072N4086APippert James R · Dysart, IABuilt 1970 · S/N D-9112N4086DThompson George M · Fairbanks, AKBuilt 1957 · S/N 34786N4086S80'S Associates Inc · Pittstown, NJBuilt 1975 · S/N D-9731N40872Ole South Aviators LLC · Athens, GAS/N 31-8152134N40874Jones Sherman Farrell · Buena Park, CABuilt 1973 · S/N 28-7425184N40876Gray John W · Rohnert Park, CABuilt 1973 · S/N 28-7415100N4087PPankratz Laura M · Stroudsburg, PABuilt 1959 · S/N 23-1565N4087ZNcsb LLC · Anchorage, AKBuilt 1964 · S/N 18-8102N40881Hsu Feng · Albuquerque, NMS/N 28-7425185N40882Flight Factory LLC · Danville, CABuilt 1973 · S/N 28-7415105N4088DIron Horse Aviation LLC · Omak, WABuilt 1957 · S/N 34788N4088FCole Warren G · Watkinsville, GABuilt 1976 · S/N 28-7725002N4088MRam Aviation LLC · Palmer, AKBuilt 1947 · S/N 12-3003SN4088PBas Part Sales LLC · Greeley, COS/N 23-1561N4089Indrebo Rick J · Livermore, CABuilt 1989 · S/N 173N4089DGaffney Justin L · Arcata, CABuilt 1958 · S/N 34789N4089FKorb Orry P · Santa Cruz, CABuilt 2002 · S/N 81452N4089SRaii3 LLC · Lewes, DEBuilt 1975 · S/N D-9732N408BWKough David M · Nashville, TNBuilt 2002 · S/N 60116N408CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881119N408CDKc Jet Sales LLC · Scottsdale, AZBuilt 2005 · S/N 1464N408CLExecutive Helicopter Tours Inc · Saint Petersburg, FLBuilt 2007 · S/N 11722N408CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282446N408EAMagnell Gregory P Trustee · Vicksburg, MIBuilt 1998 · S/N 18280139N408EPAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11439N408FHStevens William C · Ashland, MTBuilt 2012 · S/N 2012131
Back to AD 2007-04-19 R1