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.

N456RRAir America Flight Center LLC · Daytona Beach, FLBuilt 1976 · S/N 28R-7635457N456RTMassive Solutions LLC Trustee · Denton, TXBuilt 2002 · S/N 0314N456SGGavitt Stephen M · Rensselaer, NYBuilt 2010 · S/N 91307N456SPAc Aviation LLC · Ocklawaha, FLBuilt 1999 · S/N 172S8320N456STMcbride Ken · San Martin, CABuilt 1975 · S/N 414-0810N456TWestphal Eric R · Conroe, TXBuilt 1974 · S/N D-9625N456TGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2006 · S/N 11136N456THB R S Leasing Inc · Wilmington, DEBuilt 1980 · S/N ME-319N456TWSchmidt Gail M · Florence, COBuilt 2007 · S/N 02-1217N456UHAlba Leasing Services LLC · Scottsdale, AZBuilt 2014 · S/N 4655N456WMWright Alfred M · Toney, ALBuilt 2001 · S/N 001N456WPMatagorda Production Co · Westhoff, TXBuilt 1979 · S/N 340A0766N456WWJandal Group Holdings LLC · Winters, TXBuilt 1981 · S/N TJ-390N456YDodson International Parts Inc · Rantoul, KSBuilt 2000 · S/N 2843353N456ZRedpole2 LLC · Kalispell, MTBuilt 2023 · S/N 1332N4570KHead East Aviation LLC · Geneseo, ILBuilt 1979 · S/N P21000220N4570MMatthews Richard W · Kasilof, AKBuilt 2018 · S/N 040750N4570TWinslow Dean L · Stanford, CABuilt 1972 · S/N 28-7210013N4570WGuffey Jerry D · Lebanon, TNS/N 13060N4571BSchumacher Eraine · Hague, NDBuilt 1955 · S/N 31470N4571TVandeventer Matthew S · Dillingham, AKS/N 32-7200023N4571WBernard Scott Sr · Denham Springs, LAS/N 13061N4571XFly Boys Aviation LLC · Tecumseh, MIS/N 28-7690039N4571YDavis James J · Beaver Dam, WIBuilt 1967 · S/N 25-4235N4572AHyden William · Round Rock, TXBuilt 1970 · S/N D-9150N4572BPagel Jeffrey · Wasilla, AKBuilt 1955 · S/N 31471N4572FRichards Stewart G · North Palm Beach, FLBuilt 1966 · S/N 185-1079N4572SQualley Patrick Dion · Brooklyn Park, MNBuilt 1975 · S/N E-744N4572WKelton Joel B · May, TXBuilt 1976 · S/N 13062N4573FNapflin Erich P · Wasilla, AKBuilt 1966 · S/N 185-1080N4573JRoss James A · Barrington, RIS/N 28R-30438N4573RKaufmann Carl S · Springfield, MABuilt 1965 · S/N 28-21314N4574FKlingenmeyer Korey L · Anchorage, AKBuilt 1966 · S/N 185-1081N4574JWakefield Aircraft LLC · Cooperstown, NDBuilt 1968 · S/N 28R-30439N4574MSweeney Thomas J · Niles, MIBuilt 1978 · S/N D-10118N4574RKing Vincent A · Grand Junction, COBuilt 1965 · S/N 28-21316N4574TBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 34-7250137N4575BKrupinshi Floyd M · Chugiak, AKBuilt 1955 · S/N 31474N4575FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 28-7715049N4575PWings Management Co LLC · Rio Rancho, NMBuilt 1960 · S/N 27-84N4575WN4575w LLC · Santa Fe Springs, CABuilt 1976 · S/N 13065N4575XPar Mar Bluffs LLC · Parker, SDS/N 28-7690034N4576FDakota Aviation LLC · Sioux Falls, SDBuilt 1976 · S/N 28-7715050N4576KPope James Dean · Lewiston, IDBuilt 1979 · S/N P21000222N4576XElon Aviation LLC · Burlington, NCBuilt 1975 · S/N 28R-7635081N4577Gateway Of Sturgis LLC · Sturgis, MIBuilt 1999 · S/N 172S8285N4577BHorsley David L · El Paso, TXBuilt 1955 · S/N 31476N4577LLucas John · Norco, CABuilt 1972 · S/N 340-0115N4577XFairhaven LLC · Meridian, MSBuilt 1975 · S/N 32-7600004N4578NAviation International LLC · El Paso, TXBuilt 1978 · S/N 340A0553
Back to AD 2007-04-19 R1