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.

N441BGAwa Aviation LLC · Okeechobee, FLBuilt 2011 · S/N 13223N441BJB & J Flying Service · Etters, PABuilt 2004 · S/N 10528N441BMMillsap Ted I · Redding, CAS/N 28-22816N441BSValiair Lc Trustee · Casper, WYBuilt 2004 · S/N 10357N441CAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280441N441CDDb Excavation Inc · Lewes, DEBuilt 2009 · S/N 12878N441CHRegistration Pending · La Conner, WARegistration pendingBuilt 2002 · S/N 10012N441CKWinters John H · Birch Run, MIBuilt 1975 · S/N 28R-7535314N441DLewis Thomas F · Chico, CABuilt 1955 · S/N 35058N441DEWhirld Helicopters Inc · Sevierville, TNBuilt 2006 · S/N 11249N441DHDirk Henderson LLC · Palm Harbor, FLBuilt 2018 · S/N 14178N441DLPinion Aviation Inc · Glenbrook, NVBuilt 1976 · S/N 17267391N441DPRhinelander Flying Service Inc · Rhinelander, WIBuilt 1975 · S/N 17265691N441DRDakota Rotors LLC · Custer, SDFirst renewal noticeBuilt 2004 · S/N 10375N441EDGold Prop Aviation LLC · Auburndale, FLBuilt 1985 · S/N 327N441EKSkf Holdings LLC · Breckenridge, TXBuilt 2002 · S/N 1190N441ELRegistration Pending · Caledonia, WIRegistration pendingBuilt 2014 · S/N 90586N441ERVeve Jesus Vila · Mayaguez, PRBuilt 2005 · S/N 172S10060N441FLJustice Carrie · Plano, TXBuilt 1971 · S/N 28-7125230N441GSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 11764N441GWEugetech LLC · Bettendorf, IABuilt 2004 · S/N 1060N441HGGeorgia Aviation Authority · Eastman, GABuilt 1995 · S/N 4496003N441JPJpm Flying Service LLC · Marine, ILBuilt 2021 · S/N 14496N441LMLand Of Indiana Inc · Bedford, INBuilt 2024 · S/N 14736N441MA9k Air LLC · Newark, DEBuilt 2021 · S/N 4496526N441MRHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2003 · S/N 1329N441NAHendry Rickey W · Apple Springs, TXBuilt 1955 · S/N 32198N441NCCharlie Papa LLC · Van Nuys, CABuilt 2005 · S/N 10621N441PDBaton Rouge Police Department · Baton Rouge, LABuilt 2009 · S/N 12494N441PETres Vientos LLC · Santa Fe, NMBuilt 2017 · S/N 14049N441PFBusy Bee Helicopters LLC · Dover, DEBuilt 2005 · S/N 1522N441PRHuntingdon Valley Helicopter LLC · Wilmington, DEBuilt 2004 · S/N 10310N441QFChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280278N441RHHobbs Jonnie L · Darnestown, MDBuilt 1997 · S/N 0401N441SDFlicksville Flyers Inc · Bangor, PABuilt 2006 · S/N 11302N441SGChristmann Charles D · Patagonia, AZBuilt 2004 · S/N 10441N441TBMansfield Heliflight Inc · Milton, VTBuilt 1999 · S/N 0631N441THSchwarzenberg Johannes · Helena, MTBuilt 2004 · S/N 10334N441TJRylee LLC · Lawrence, KSBuilt 1979 · S/N 18267141N441TPUnited Contractors Inc · Costa Mesa, CABuilt 1978 · S/N 414A0057N441TTSunbird Airlines Inc · San Juan, PRBuilt 1981 · S/N 402C0441N441TXSky Helicopters Inc · Garland, TXBuilt 2009 · S/N 12521N441VBHampton Roads Charter Service · Chesapeake, VABuilt 2025 · S/N 14902N441WCMoore Jeremy Emmett · Baton Rouge, LABuilt 1978 · S/N TC-2181N441WHElevate Heli LLC · Harrison, NYBuilt 2026 · S/N 14965N441WSFord Mark L · New Cambria, KSBuilt 1966 · S/N 670049N441WW4kd Corporation · Wilmington, DEBuilt 1975 · S/N CE-606N44203Skyline Solutions Inc · Deland, FLBuilt 1974 · S/N 28-7415600N4420JSilver Wings Aviation LLC · El Paso, TXBuilt 1967 · S/N 28-24067N4420RPeterson Reid E · Minnetonka, MNBuilt 1974 · S/N 17263167
Back to AD 2007-04-19 R1