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.

N4799SMiller Charles B · Pass Christian, MSBuilt 1969 · S/N 32-1184N4799TSale Reported · Omaha, NESale reportedBuilt 1972 · S/N 28-7205197N4799UChase 13 LLC · Wilmington, DEBuilt 1965 · S/N 18051499N4799VDeparture Aviation Services LLC · Laurel Hill, NCS/N 30088N4799WHudson Kelsey L · Snohomish, WABuilt 1977 · S/N 14119N479ACVick Vernon A · Dublin, OHBuilt 1999 · S/N 427-99N479BAJml Aviation Inc · Jonesboro, ARBuilt 2014 · S/N E-4056N479BKTensas Taildraggers LLC · Saint Joseph, LABuilt 2017 · S/N 153N479CNFlight World Inc · San Juan, PRBuilt 1975 · S/N 17266007N479EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11601N479FLImmell John A · Chillicothe, OHBuilt 1971 · S/N 28-7125285N479HBDouble Bar Stationair LLC · Coeur D Alene, IDBuilt 1975 · S/N U20602923N479JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020079N479JLLopez Jesus D · Garfield, ARS/N 18264124N479JPHogancamp John M · Lebanon, TNBuilt 1976 · S/N E-801N479NTFlight World Inc · San Juan, PRBuilt 1975 · S/N 17265279N479SHParker Helicopter LLC · Watsonville, CABuilt 2006 · S/N 4058N479SVKollstedt Lance S · Tipp City, OHBuilt 1979 · S/N 79-30950N479TWilson Chuck W · Mckinney, TXBuilt 1961 · S/N CD-425N47ACReabe Aircraft Improvement Inc · De Pere, WIBuilt 1974 · S/N 3200N47AEPolar Air LLC · Bozeman, MTBuilt 2007 · S/N 18100CN47AFL & J Aviation Inc · Atwater, CABuilt 2001 · S/N 17281041N47AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1972 · S/N 340-0114N47APAfrican Parks Aviation Inc Trustee · Cheyenne, WYBuilt 1983 · S/N U20606768N47ASM D Ham LLC · Conover, NCFirst renewal noticeBuilt 1998 · S/N 21048CN47ATPutman William C · Bigfork, MTS/N 147N47BBRogers Joseph O III · Fernandina Beach, FLBuilt 1960 · S/N 24-1889N47BCBrentech Leasing LLC · Cartersville, GABuilt 1988 · S/N 4608129N47BDFlydreams Corp · Lewes, DEBuilt 2007 · S/N 11943N47BGVonweisenstein Thomas W · Brentwood, TNBuilt 1974 · S/N 310Q1061N47BLLade Burton G · Bemidji, MNBuilt 2010 · S/N 003N47BNCavorite Aviation LLC · Lehi, UTBuilt 1995 · S/N 28-43020N47CDRs Aviation Services · Moorpark, CABuilt 2008 · S/N 4350N47CFHover 32768 LLC · Kalispell, MTBuilt 2007 · S/N 11631N47CPHibler Philip Earl · Alameda, CABuilt 1957 · S/N 32304N47CTSweetwater Flyers LLC · Emporia, KSBuilt 1972 · S/N 17701769N47CWPetersen Alfred Charles · Buffalo Grove, ILBuilt 1986 · S/N 840N47DBCala Brush Supply Inc · Weslaco, TXBuilt 1978 · S/N P21000175N47DCL&D Joint Sealing LLC · Fairbury, NEBuilt 1985 · S/N 3515N47DERichards Ronald W · Grant City, MOBuilt 1996 · S/N 23106N47DHBeard Donald Ray · Bulverde, TXBuilt 1983 · S/N 129N47DLFairley Michael L · Shawnee, KSS/N 608-320-354N47DSHalls Dave · Lilburn, GABuilt 1959 · S/N 39005N47ECRv Aviation LLC · Wilmington, DEBuilt 2009 · S/N 5130N47EEGt Aviation Solutions LLC · Mount Juliet, TNS/N 27-2009N47EYWof Investments LLC · Dover, DES/N 2359N47EZRinell Eric S · San Luis Obispo, CABuilt 2020 · S/N 0002N47FAAshe Olen Reid Jr Trustee · Winston Salem, NCBuilt 2004 · S/N 0965N47FL3429 Capital Holdings LLC · Jupiter, FLBuilt 2024 · S/N 3429N47GEMcbride Michael J · Loxley, ALBuilt 1978 · S/N 18266717
Back to AD 2007-04-19 R1