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.

N44CYMiskell Christopher S · Senoia, GABuilt 1973 · S/N TC-1629N44CZHeer James A · Lutz, FLBuilt 1988 · S/N 1N44DADuncan Aviation Inc · Lincoln, NEBuilt 1981 · S/N E-1841N44DBSperr David F · Rock Hill, SCBuilt 1959 · S/N D-6074N44DGTime Flies LLC · Fort Worth, TXS/N 055N44DMGorge Winds Aviation Inc · Fairview, ORBuilt 1973 · S/N 17261488N44DPD L S Aviation Inc · Wilmington, DEFirst renewal noticeBuilt 1968 · S/N 310P0039N44DQTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2005 · S/N 10821N44DRFiretextresponse LLC · Sumner, ILBuilt 1975 · S/N 18263596N44DWGrumman Widgeon LLC · Missoula, MTS/N 1381N44DZWanted Poster Owners Group LLC · York, PABuilt 1973 · S/N 32-7300046N44ECN44ec LLC · Caddo Mills, TXBuilt 1980 · S/N 21063972N44EEEchemann Thomas A · Sidney, OHBuilt 1979 · S/N 21063723N44EKBas Part Sales LLC · Greeley, COS/N 0690N44EWPlane Fun Inc Tr Trustee · Snellville, GABuilt 1978 · S/N 1-0058N44FATemple Craig A · Fort Lauderdale, FLBuilt 1980 · S/N 20700659N44FDHildreth David M · Kennesaw, GABuilt 1956 · S/N 23-500N44FGSaratoga Helicopter LLC · Queensbury, NYBuilt 2016 · S/N 13925N44FSJinsky Ronald G · Beloit, WIBuilt 1975 · S/N 717N44GAFly Qts LLC · Oconomowoc, WIBuilt 1978 · S/N 414A0036N44GDCarver Michael A · Ocala, FLBuilt 2009 · S/N 004N44GNMitchell Martin B · Newport Beach, CABuilt 1975 · S/N CE-620N44GZOpdahl Kirk J · Lees Summit, MOBuilt 1993 · S/N CE1725N44HALaps LLC · Elkhorn, WIBuilt 1984 · S/N 46-8408026N44HDAir Assault Agricultural Aviation LLC · New Castle, VABuilt 2005 · S/N 1498N44HGHigher Ground Helicopters Of Cincinnati LLC · Miamisburg, OHBuilt 1995 · S/N 0214N44HKBradt Joseph J · Inver Grove, MNBuilt 1997 · S/N 79597N44HNCedar Ridge Aviation LLC · Knox City, TXBuilt 2005 · S/N 1455N44HRCardinal Aviation Services LLC · Castle Rock, COBuilt 1978 · S/N 21062685N44HUFritsche James G · Greenleaf, WIBuilt 1997 · S/N 1353N44HVMarinella Steve · Chandler, AZBuilt 2003 · S/N 6056N44HYCochran Thomas S · Fort Collins, COBuilt 2001 · S/N 2145N44JAJersey Aero Club Inc · Lakewood, NJBuilt 1983 · S/N 32-8306031N44JFEureka E Solutions Inc · Austin, TXBuilt 1973 · S/N 18262579N44JGLiberty Industries LLC · Washington, DCBuilt 1965 · S/N 18256867N44JKKirkman Todd · Chetek, WIS/N CE-102N44JLBushcat Goldie LLC · Oro Valley, AZBuilt 2015 · S/N 72279N44JRRodgers Jerry T · Bishop, CABuilt 1997 · S/N 24545N44JUEcho Mike Consulting LLC · Wilmington, DEBuilt 2004 · S/N 10517N44KCSpitfire Ix Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 2003 · S/N 0516N44KDSale Reported · Crystal, MNSale reported, canceledBuilt 1972 · S/N 28R-7235106N44KFEbert Construction Co Inc · Wamego, KSBuilt 1974 · S/N 421B0598N44KGSpanogle Michael M · Chugiak, AKBuilt 1989 · S/N 4074CN44KLStell Brandon A · Mechanicsville, VAS/N 803N44KPHargrave Margarite D · Seattle, WABuilt 1978 · S/N 172-70904N44KRMcilhenny Edward A · Clayton, GABuilt 1983 · S/N EA-358N44KVHughes Eugene F Jr · Butte, MTBuilt 2005 · S/N 11003N44KYBas Part Sales LLC · Greeley, COS/N 11307N44LETp Aviation LLC · Redding, CABuilt 2009 · S/N 3058N44LKCessna Skyhawk LLC · Parker, COFirst renewal noticeBuilt 1979 · S/N 17273400
Back to AD 2007-04-19 R1