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.

N499DRWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 172S9167N499EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11604N499ETQualitair LLC Owner Trustee · MichesltadtBuilt 2006 · S/N 18281808N499FLSchrock Derrick L · Jesup, GABuilt 1971 · S/N 28-7125316N499KWRidgeline Assets LLC · Wilmington, DEBuilt 2000 · S/N 172S8430N499LCLimocopter LLC · Orlando, FLBuilt 2023 · S/N 2732N499LTTurk Lance G · Omak, WABuilt 1982 · S/N 499N499MBCook Joshua D - Trustee · Nashville, TNBuilt 1964 · S/N D-7587N499MMBrown George P III · Houston, TXS/N 18261871N499RARenegade6 Aviation LLC · Woodbridge, VABuilt 2008 · S/N 411042N499SCurcio Joseph A · Granite Bay, CABuilt 1970 · S/N 18260228N499TCLieberman Richard M · Hellertown, PABuilt 1978 · S/N TC-2136N499TGCrest Aviation LLC · Broomfield, COS/N 28-7425318N499UVUtah Valley University · Orem, UTBuilt 2019 · S/N 4496454N499WLee Chris · Granger, INBuilt 2004 · S/N 40.423N499WBStenson Ryan · Newton, NHS/N 07001N499WLMatthews Joseph D · Farr West, UTBuilt 1968 · S/N 18259153N499ZGold Leaf Aviation LLC · Mount Airy, NCBuilt 1962 · S/N TC-281N49AJLvml Real Estate Investments LLC · Rio Grande City, TXBuilt 1978 · S/N P21000059N49AKIllig Peter E · Anchorage, AKFirst renewal noticeBuilt 1956 · S/N 22-3814N49AVHetrick Buzz · Overland Park, KSS/N M11-251N49CAMagarin Aircraft LLC · Haslet, TXBuilt 1961 · S/N TC-214N49CFWtf Partnership · Anchorage, AKBuilt 1976 · S/N 18-7609110N49CGLeading Edge Flight Academy LLC · Bend, ORBuilt 1973 · S/N 17262238N49CMS & B Aviation LLC · Incline Village, NVBuilt 1998 · S/N 357N49CNVenture Air LLC · Leonard, NDBuilt 1999 · S/N 0554N49CSDoherty Sean M · Collinsville, OKBuilt 1980 · S/N SAWKA 0001N49DCenturian 94n LLC · Ripon, CABuilt 1974 · S/N TH-542N49DBBabcock David A · Puyallup, WABuilt 1995 · S/N 3389N49DPPrince David A · Homer, AKBuilt 1975 · S/N 18-7509035N49DRRussell Thomas P · Milo, MEBuilt 2001 · S/N 2001-1N49EELessley Aviation LLC · Carrollton, MSBuilt 1998 · S/N 1239-98N49ELPitts Flight Certification LLC · Nipomo, CABuilt 2024 · S/N E-4158N49ESToby Louis J · Waterford, MIS/N 319N49EXReinhard Metz · Wheaton, ILBuilt 1997 · S/N 01N49EZMagner Gregory R · Lakeville, MABuilt 2005 · S/N 2001N49GCFinnegan Kevin · Indialantic, FLBuilt 1968 · S/N TE-585N49GLBobo Robert A · Pullman, WABuilt 1960 · S/N 50705N49GPMartin Dale · Lubbock, TXBuilt 1964 · S/N 18255401N49GTKugielsky Benjamin W · Newtown, CTBuilt 1975 · S/N AA5B-0116N49GWWymer Gerald A · Edgewood, NMBuilt 2011 · S/N 239N49HPFour Niner Hotel Papa LLC · Grosse Pointe Park, MIBuilt 2007 · S/N 2381N49HRBon-36 Ltd · Shavano Park, TXBuilt 1993 · S/N E-2790N49HYMusbach James I · Pacific Grove, CABuilt 2002 · S/N 2212N49JBTilley Robert E · Albany, GABuilt 2013 · S/N 049N49JFBearce Jonathan R · Rosamond, CABuilt 1997 · S/N DMO-051N49JGCavanaugh James Martin Jr · Ann Arbor, MIBuilt 1990 · S/N CE-1505N49JKWilliams Casey D Trustee · Wasilla, AKBuilt 1954 · S/N 18-3329N49JLPalmetto Aviation Solutions LLC · Woodruff, SCBuilt 1975 · S/N E-746N49JMScott L Geller Co · Fort Myers, FLBuilt 1989 · S/N M1
Back to AD 2007-04-19 R1