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.

N5755VArnold Alan Dale · Glenwood Springs, COBuilt 1966 · S/N MA-16N5755WSchmidt Mia H · Van Nuys, CABuilt 1963 · S/N 28-1499N57562Sitter Timothy L · Anchorage, AKFirst renewal noticeBuilt 1978 · S/N 18-7809093N5756BWages Brent · Rupert, IDBuilt 1956 · S/N 33756N5756FStewart Larry E · Seymour, INBuilt 1968 · S/N 28-25059N5756QDominguez Juan · Austin, TXBuilt 1965 · S/N 3080N5756YLamascus Mark S · King City, CAS/N 18-8325N5757BWilson Chad R · Port Angeles, WAS/N 33757N5757CRoberts Justin · Livingston, MTBuilt 1980 · S/N 340A0975N5757D57 Delta LLC · Grand Prairie, TXS/N CD-1092N5757EFlex Air Inc · San Diego, CABuilt 1978 · S/N 17271935N5757FWaletzko David L · Avon, MNBuilt 1968 · S/N 28-25060N5757JAdams Gary A · Alva, OKBuilt 1971 · S/N 21059457N5757WN63e LLC · Fallon, NVBuilt 1964 · S/N 28-1527N5758BBentley John · Bend, ORS/N 33758N5758FTipnis Zachary Arjun · Troy, NYS/N 28-25061N5758JBatchelder Wesley · Palacios, TXBuilt 1980 · S/N 17273833N5758PBarr Michael J · Colorado Springs, COBuilt 1959 · S/N 24-834N5758QAviation Forza Inc · Pompano Beach, FLS/N 3081N5758VNelson Mike R · Philip, SDS/N MB-41N5759FGelnett Dean A · Lansdale, PABuilt 1968 · S/N 28-25062N5759JThree Six Golf Ltd · Cary, NCBuilt 1974 · S/N 18263522N5759PDemars Michael · California, MDBuilt 1959 · S/N 24-836N5759WChimera Air Inc · Maumee, OHBuilt 1964 · S/N 28-1529N575AAHanson Dirk Allen · Moorhead, MNS/N 205-0322N575ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496203N575BFreedom Flight Inc · Southlake, TXBuilt 2007 · S/N 27N575BBZielich Matthew · Glendale, AZBuilt 1975 · S/N 28-7515378N575BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881958N575CDG2 Aero LLC · Chattanooga, TNBuilt 2004 · S/N 0936N575CKKincer Charles L · Richmond, MEBuilt 1975 · S/N 200N575DCArmadillo Aviation LLC · Hummelstown, PABuilt 1979 · S/N 32R-7985105N575DGSeamount Robert E · Milton Freewater, ORS/N 218N575DKTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2025 · S/N 18283291N575DSGotfredson Allen S · Ten Sleep, WYBuilt 1975 · S/N 885-75N575GMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1998 · S/N 1872N575GWNeuse Aviation LLC · Smithfield, NCBuilt 2001 · S/N E-3390N575HBHot Damn Flying Service LLC · Palm Coast, FLBuilt 1973 · S/N 310Q0788N575JHDunbar Stephen E Trustee · Broken Arrow, OKBuilt 1975 · S/N 75-30791N575L575 LLC · Fairbanks, AKS/N 1463N575MKEngstad Kai · Gig Harbor, WABuilt 2026 · S/N 41734N575NDAir Shares LLC · Casper, WYBuilt 2009 · S/N 172S10954N575NVSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N TE-705N575PAGrw Air Services LLC · Springport, INBuilt 1975 · S/N 28-7525330N575PMLiebfried Andrew H · Lunenburg, MABuilt 1975 · S/N 18264045N575RVEzzo Donna L · Lancaster, NYBuilt 2006 · S/N 70479N575SDBlue Sky Aviation LLC · Menominee, MIBuilt 2023 · S/N 2881633N575SLPhipps Vaughn Pago · Chattanooga, TNBuilt 1964 · S/N D-7342N575SPCharlie Leasing LLC · Green Bay, WIBuilt 2000 · S/N 172S8504N575SWHester Thomas F · Santa Barbara, CABuilt 1979 · S/N 414A0268
Back to AD 2007-04-19 R1