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.

N39AHCapital Aircraft LLC · Juneau, AKBuilt 2001 · S/N 2140N39AKRenfro Michael W · Bethel, AKBuilt 1980 · S/N 20700597N39ALMcentire David J · Bainbridge, INBuilt 2005 · S/N 01N39BCRoberts David C · Cedar Falls, IABuilt 1973 · S/N 28-7410013N39BPEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1999 · S/N 2906N39BSTravark LLC · Gainesville, GABuilt 1970 · S/N CD-1250N39BTMidwest Aerial Photography · Galloway, OHBuilt 1974 · S/N 310Q1137N39CCWard Bobby J · Dalhart, TXBuilt 1975 · S/N 18502858N39CMZarum Robert S · Mashpee, MABuilt 1965 · S/N CD-910N39CPWhirl'D Helicopters Inc · Sevierville, TNBuilt 2003 · S/N 10069N39CSRegistration Pending · Pinckney, MIRegistration pendingBuilt 2026 · S/N 15002N39CTRotramel Paul D · Hardinsburg, KYBuilt 1968 · S/N 28R-30712N39CWWindham Charles R · Rogersville, TNBuilt 2012 · S/N 91447N39DBKwasinski Mark W · Kalamazoo, MIBuilt 1969 · S/N 153N39DCCruson Dale E · Ontario, ORBuilt 1993 · S/N 20374N39DDLarson Danny O · Palmer, AKBuilt 1973 · S/N 340-0246N39DRLehigh Valley Flying Club Inc · Lehigh Valley, PABuilt 1976 · S/N 28-7790221N39DUYokoo Kureha · Petaluma, CAS/N 22818N39ECSmith Adria A · Kingwood, TXBuilt 1968 · S/N 28-4985N39EJAndersen John · Kenosha, WIBuilt 2006 · S/N 39N39FCStout Keith · Salmon, IDBuilt 1979 · S/N 18503923N39FZLongley Charles A · Nome, AKBuilt 1962 · S/N 18-7745N39GMonteleone Gene R · Mount Vernon, TXS/N 15N39GCWilliams Jeffrey D · Florence, ALBuilt 1980 · S/N AS123N39GDNovember Sierra Romeo LLC · Byron Center, MIS/N 10250N39GHApaka Lee K · Fairfield, CABuilt 1975 · S/N 65N39GMBacon Gregory A · Prairie Home, MOS/N 0001N39GPExtra 2 Inc · Newark, DEBuilt 2000 · S/N 116N39GSAir Flight Enterprises Inc · South Daytona, FLBuilt 2007 · S/N 11624N39GTAshwill Gregory L Trustee · Overgaard, AZBuilt 2018 · S/N SC-100N39GWKotalite Consultant LLC · West Palm Beach, FLS/N 3096N39HBBartle Henson P · Independence, ORBuilt 2012 · S/N 1N39HCTherapy Air LLC · Midland, TXS/N 414-0469N39HWApple & Vine Aviation Services LLC · Reidsville, GABuilt 2000 · S/N 29-0215N39HYReed Hollow Aviation LLC · Franktown, COBuilt 2001 · S/N 2137N39JApex 1996 LLC · Kilgore, TXS/N 18052274N39JBHarvey Hath R · Lubbock, TXBuilt 1988 · S/N CE-1233N39JLLundberg Jonathan S · Fayetteville, TNBuilt 2012 · S/N 1115-2012N39JMJads Aviation LLC · Rowlett, TXBuilt 1960 · S/N 23-1943N39KWFier William J · Austin, TXBuilt 2000 · S/N 3374N39LDMau Thomas E · Kenmare, NDS/N 18-5757N39LTGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 924-2003N39MPMission Aviation Training Academy · Arlington, WABuilt 1965 · S/N U206-0288N39MRGraupman Gerald · Chicago, ILBuilt 1969 · S/N EGA-1N39MVMedical Transport Inc · Dover, DES/N 61P07728063385N39NDTerwillegar Charles E · Renton, WABuilt 1967 · S/N R1720082N39NSMacair Inc · Corvallis, ORBuilt 1998 · S/N 2003N39PCN39pc LLC · Portsmouth, NHBuilt 1983 · S/N 18268313N39PRAeroplanes LLC · Cary, NCBuilt 1965 · S/N TE-23N39PSSmith Justin Dean · Dayton, TNS/N 18258921
Back to AD 2007-04-19 R1