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.

N4266QMaxwell James B · Lewiston, IDBuilt 1971 · S/N 17260166N4266ZVan Ryzin Chris K · Sterling, AKBuilt 1967 · S/N 18-8512N42671P&N Corp · Marion, IABuilt 1974 · S/N 28-7415398N42672Dowden Lairon W Jr · Nederland, TXBuilt 1968 · S/N 18259131N42673Chase Donald C · Erie, PABuilt 1968 · S/N 18259132N42675908 Flying Club Inc · Fort Pierce, FLBuilt 1974 · S/N 28-7405165N42677Swank And Son Inc · Poplar, MTBuilt 1975 · S/N AA5B-0074N42678Merow Michael C · Algoma, WIBuilt 1968 · S/N 18259135N4267HGmt Enterprises LLC · Stephenville, TXFirst renewal noticeBuilt 1978 · S/N 24-0690N4267QDhf LLC · Valentine, NEBuilt 1971 · S/N 17260167N4267THooley Charles M · North Oaks, MNBuilt 1971 · S/N 28-7225110N42687Cal Coast Reps Inc · Costa Mesa, CABuilt 1968 · S/N 18259138N42689Alc Aviation LLC · Waseca, MNBuilt 1968 · S/N 18259140N4268FWindt Edward A Jr · Chester, NJS/N 28-7790008N4268JLuxair LLC · Van Nuys, CAS/N 28-22626N4268PAhlem Mark · Hilmar, CABuilt 1959 · S/N 23-1767N42693Paul D Barkhurst Pc · San Antonio, TXBuilt 1968 · S/N 18259141N42694Jaffa Bruce E · Moose Pass, AKBuilt 1968 · S/N 18259142N42698Bruch Stein · Randolph, MNBuilt 1968 · S/N 18259145N4269BNortheast Aviation LLC · Bynum, TXBuilt 2000 · S/N 25047CN4269HSiniakin Michael K · East Brunswick, NJBuilt 1978 · S/N 24-0692N4269JMasino John B Jr · Berlin, MDBuilt 1967 · S/N 28-22628N4269TRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1972 · S/N 28-7205126N4269UAero380 Corp · Wilmington, DEBuilt 2017 · S/N 30021N426ASSaylor Alvin N Jr · Friendswood, TXBuilt 1970 · S/N P206-0590N426CPCivil Air Patrol · Montgomery, ALBuilt 2001 · S/N 172S8688N426CTAir Kraft Aviation LLC · Timber Lake, SDS/N 11174N426CUMiller Justin S · Cedar Rapids, IABuilt 2021 · S/N 4261986N426DDRare Air Aviation Services LLC · Santa Rosa, CABuilt 1970 · S/N TH-93N426DLHawk30 Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172RG0827N426ESWeaver Corey E · Saline, MIBuilt 1997 · S/N 17280263N426HHickerson Timothy William · Springfield, OHBuilt 2003 · S/N 81246N426HLGiurtino Joel F · Spring Hill, FLBuilt 1977 · S/N 17269050N426JGAero Flight School No7 LLC · Lincoln Park, NJBuilt 2008 · S/N 172S10862N426JKHuku 2 LLC · Princeton, NJBuilt 2019 · S/N 14367N426JMThompson Daniel · Catawba, NCBuilt 1999 · S/N 60191N426JTReilly Michael R · Vestal, NYBuilt 1998 · S/N 750N426KFFaris Kevin D · Plattsmouth, NEBuilt 2007 · S/N 70710N426KXCoulman Michael A · Highland Village, TXBuilt 1962 · S/N D-7067N426LJVenture Air Solutions Inc · Opa Locka, FLBuilt 1981 · S/N 402C0434N426LPAir Mates Flying Club Inc · Northfield, NJBuilt 1999 · S/N 172S8199N426MBTimothy Harty · New Richmond, WIBuilt 1984 · S/N 18504420N426MCMagic Carpet LLC · Wilmington, DEBuilt 1971 · S/N 17260022N426NCHargrave Bobby P · Cantonment, FLBuilt 2000 · S/N 80706N426PAN426pa LLC · New Orleans, LABuilt 2001 · S/N 2843475N426PKMiddendorf Brian Jay · Alamogordo, NMBuilt 2009 · S/N 91404N426PTWinter Livestock · Dodge City, KSBuilt 2007 · S/N E-3783N426PWElectron International Aviation LLC · Phoenix, AZBuilt 2020 · S/N 18283111N426RBChristiansen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 172S11134N426RCDahl Christopher E · Sutter Creek, CABuilt 1987 · S/N 26
Back to AD 2007-04-19 R1