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.

N56LAGroat Stanley G · Austin, ARBuilt 1979 · S/N 973N56LBArlington Flight Services Inc · Arlington, WABuilt 1959 · S/N TD-279N56LGLake Skippers LLC · Park Rapids, MNBuilt 1976 · S/N 18-7609051N56LJL & J Aviation Inc · Atwater, CABuilt 1979 · S/N 17272751N56LKAlbritton Randy L · Camas, WABuilt 2001 · S/N 123N56LRSpeed And Angels LLC · Kalispell, MTBuilt 2019 · S/N 1-5N56LUService Oriented Aviation Readiness S.O.A.R. · Bolivar, MOBuilt 2016 · S/N 172S11727N56MNugent David R · Jensen Beach, FLBuilt 1960 · S/N 52761N56MAMinuteman Aviation Inc · Missoula, MTBuilt 1976 · S/N 340A0067N56MELuttrell Jabe · Key West, FLBuilt 1977 · S/N 340A0316N56MWHeartland Ag Aviation LLC · Lancaster, KSBuilt 1975 · S/N 17265314N56NAHampden Aviation Services Inc · Northampton, MABuilt 1979 · S/N 28-8016073N56NHBarreto Manufactuering Inc · La Grande, ORBuilt 2010 · S/N 3097N56NLExtra Air LLC · Port Orange, FLBuilt 1977 · S/N R18200084N56NTJet Air Inc · Iowa City, IABuilt 1955 · S/N G-778N56PFLucero John · Long Key, FLBuilt 2002 · S/N 0274N56PPGray Charles C · Westmont, ILBuilt 1996 · S/N 20478N56PSLeonard Paul N · Ewa Beach, HIS/N 5306N56RGMangelsdorf David M · Raton, NMBuilt 1980 · S/N TG-2N56RPPeplinski Robert E · Sullivan, WIBuilt 2004 · S/N 865N56RVLudtke Frederick · Freeland, WAS/N 20005N56RWFilice Mario · Minden, NVBuilt 1980 · S/N 555N56SCHighley Robert W III · Aldie, VABuilt 1975 · S/N AA5-0754N56SELuts Phillip · Escondido, CABuilt 1999 · S/N 24682N56SGGlemba Stuwart T · Mesa, AZBuilt 1977 · S/N 1056N56SJShaw Kenneth F · Redding, CABuilt 1999 · S/N 1267-99N56SPGlenn Aviation Services Inc · Wilsonville, ALBuilt 1996 · S/N 23088N56TABarber Jason L · Oil Trough, ARBuilt 1998 · S/N 1420N56TBHernandez Holdings Lp · Coral Gables, FLS/N 492N56TJTrue North Aviation LLC · Leclaire, IABuilt 1981 · S/N 414A0804N56TLAviation Manpower Solutions Inc · Nashville, TNBuilt 1990 · S/N TH-1597N56TMPoint Two Mmo Aviation · Lake Stevens, WABuilt 1961 · S/N TC-189N56TVKoerper Md LLC · Las Cruces, NMBuilt 1984 · S/N 18268399N56UD&M Aviation Inc · Amelia, OHS/N 139N56WACarter Cameron T · Buffalo, NYBuilt 1983 · S/N 603N56WBTmr Aviation LLC · Fredericksburg, VAS/N 28-4470N56WDParvez Dara · Toms River, NJBuilt 2007 · S/N E-3807N56WGErickson Lynn A · Prairie Du Sac, WIBuilt 2018 · S/N 1474-2018N56WHSteamboat Ridge LLC · Kaiser, MOBuilt 1967 · S/N D-8395N56XLAltitude Aviation Services LLC · Mountain Home, IDS/N 3RX048N56YAKellner Marvin M Jr · Lampasas, TXBuilt 1956 · S/N 20-021N56YYSale Reported · Centerville, UTSale reported, pending cancellationBuilt 1972 · S/N 69-1N56ZZAmerican Flight Museum Inc · Topeka, KSS/N G-798N57006Olsen Chad · Hendricks, MNBuilt 1973 · S/N 28-7415034N5700ERegistration Pending · Fort Lauderdale, FLRegistration pendingBuilt 1978 · S/N 17271923N5700FTubbs Arthur R · Audubon, NJBuilt 1968 · S/N 28-24849N5700KNeel Aviation LLC · Lakeland, FLBuilt 1964 · S/N TC-702N5700MPangaea Air Service Inc · Aspen, COBuilt 1965 · S/N 185-0857N5700PEdmundson George · Burlington, WABuilt 1959 · S/N 24-773N5700WViriyaphap Chattada · Birmingham, ALBuilt 1963 · S/N 28-1104
Back to AD 2007-04-19 R1