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.

N32MAMccreery Aviation Co Inc · Mcallen, TXBuilt 2013 · S/N 3196N32MBMarin Airmen Inc · Mill Valley, CABuilt 1969 · S/N E-160N32MCCook Tracy L · Prosper, TXBuilt 1974 · S/N 21060482N32MEHarris Steve V · Springtown, TXBuilt 1984 · S/N 1733N32MPAshford Aviation Inc · Dothan, ALBuilt 1981 · S/N 172RG1019N32NAHampden Aviation Services Inc · Northampton, MABuilt 1982 · S/N 28-8316023N32NBSteele Kathleen N · Scottsdale, AZBuilt 1990 · S/N CE-1514N32NCEcho 7 Systems LLC · Lewes, DEBuilt 1999 · S/N 21989N32PDAsp Victor · Shoreline, WABuilt 1973 · S/N 28R-7435091N32PLDiette Paul S · Middlebury, VTBuilt 1980 · S/N 18267595N32PPDenison Aviation Inc · Atlantic, IABuilt 1964 · S/N D-7702N32PXKustatan Leasing LLC · Kenai, AKBuilt 1976 · S/N U20603343N32QXSpacewalker 2 LLC · Ocala, FLS/N 32091N32RFPulford Robert A · Barkhamsted, CTBuilt 1978 · S/N 32-7800001N32RLVb Glass Company Inc · Jamestown, CAS/N U20605551N32RPHelijet2025 Inc Trustee · Wilmington, DEBuilt 2015 · S/N 13834N32RQI C Aviation LLC · Birmingham, ALBuilt 1975 · S/N 692N32RTKnop Jeffrey Brian · Mount Juliet, TNBuilt 1978 · S/N 32R7987008N32RVTimbie Peter W · Palatka, FLBuilt 1997 · S/N 22253N32RWSkylens LLC · Hammond, LABuilt 1971 · S/N 27-4667N32SAAmoretti Remor Vinicius · Gardena, CABuilt 1977 · S/N 28-7725174N32SEV2 Aviation LLC · Mishawaka, INBuilt 2012 · S/N 82960N32SHFuller Jon A · Goliad, TXS/N 0599N32SKKukolich Stephen G · Tuscon, AZBuilt 1977 · S/N AA5A0492N32SPCochran Gene P · Silverdale, WABuilt 1976 · S/N 28-7690199N32SRBadenhope John R · Greeneville, TNBuilt 1983 · S/N RDS-01N32SXDorans Aviation LLC · Yardley, PABuilt 2004 · S/N 3232022N32TCarolina Blue Aviation LLC · Villanova, PABuilt 1978 · S/N 18266670N32TAVan Wyk Kenneth W · Pella, IABuilt 1968 · S/N E-120N32TBBoyland Todd · Solon, OHBuilt 1980 · S/N EA-77N32THKrakeel James A · Mount Pleasant, SCBuilt 1990 · S/N TH101N32TLJonesboro Cycle And Atv LLC · Bone, ARBuilt 1974 · S/N 310R0032N32VSpeer Aviation LLC · Evansville, INBuilt 1977 · S/N 340A0250N32VACommonwealth Of Virginia · Richmond, VABuilt 1974 · S/N 182-63322N32VGRegistered aircraftBuilt 1997 · S/N 2773N32VSCraftline LLC · Delray Beach, FLS/N 340-0025N32VTWinging It LLC · Louisville, KYBuilt 1979 · S/N 32-7940029N32VUVincennes University · Vincennes, INBuilt 2018 · S/N 4496430N32WFN32wf LLC · Muscatine, IAS/N 3246026N32WHEagle Air Partners LLC · Bartlett, TNBuilt 1977 · S/N E-1184N32WTEdwards Anthony C · Weaverville, CABuilt 1990 · S/N 1495N32WWOcchipinti Mark A · Springdale, ARBuilt 2008 · S/N 72384N32WYCassetta Thomas · Dundee, NYS/N 3111N32YAFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1980 · S/N 17273862N32YBHjelle Mark L · Barrett, MNBuilt 2000 · S/N 80613N32ZZJp Lemke Aviation LLC · Jenison, MIBuilt 1977 · S/N 18265469N33000Sindlinger Lyle · Puyallup, WABuilt 1971 · S/N HH-1N33001Peak Builders Inc · San Diego, CAS/N 28-7525134N33006Hawks Travis · Mount Vernon, MOS/N 28R-7535105N3300FCarter Flygare Inc · Sacramento, CABuilt 1962 · S/N CD-443
Back to AD 2007-04-19 R1