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.

N3908FRegistration Pending · Anchorage, AKRegistration pendingBuilt 1976 · S/N 28-7615431N3908QShamrock Flying Service LLC · Denver, COBuilt 1971 · S/N 17260008N3908TAustin Christopher · Dayton, NVBuilt 1967 · S/N 28R-30243N3908ZWiederkehr Air Inc · Palmer, AKBuilt 1961 · S/N 18-7721N3909CJames Eric A · Claremore, OKBuilt 1968 · S/N 17257032N3909DDavidson Danny F · Anchorage, AKBuilt 1957 · S/N 34609N3909KRada Norman · Hagerstown, MDBuilt 1967 · S/N 28-23776N3909QAdventure Seaplanes LLC · Tower, MNBuilt 1971 · S/N 17260009N3909TAnnis Aviation LLC · Gray, GABuilt 1967 · S/N 28R-30244N3909WMargolien Brooks · Orange, MABuilt 1967 · S/N 32-855N390ACEtcheverry Raymond L · Sunriver, ORS/N 491-2006N390AKJerry Trimble Helicopters Inc · Mcminnville, ORBuilt 2009 · S/N 12887N390BMontoya Aviation LLC · Glenview, ILBuilt 1957 · S/N D-4974N390CCKenmore Air Harbor LLC · Kenmore, WABuilt 2002 · S/N 9944CCN390HWRojecki Stephen T Trustee · Navarre, FLBuilt 1967 · S/N D-8608N390LFAcadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1989 · S/N CE-1378N390MEMccabe Eugene · Fremont, CABuilt 2000 · S/N 18280862N390MFDavies Thomas N · Anacortes, WABuilt 2003 · S/N 0039N390MSStack Brian James · Paso Robles, CABuilt 1981 · S/N 32-8106048N390RSSchoene Edward C · Springfield Center, NYBuilt 1976 · S/N 21061514N390TCD & J Aviation LLC · Apopka, FLBuilt 2007 · S/N 2842290N390TTOlsoe Jonathan · Eagle, IDFirst renewal noticeBuilt 2008 · S/N 5601N390UChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 4496025N390WWalter Paul F · Milwaukee, WIBuilt 1970 · S/N 39-39N390XNovak Matt E · Port Orchard, WABuilt 1976 · S/N 7028CN3910ARzepka Rick · Solon, OHBuilt 1970 · S/N D-9093N3910NStratus Aviation Group LLC · Washington, DCBuilt 1968 · S/N 680058N3910TSpeelman Jonathan D · Stockton, CABuilt 1967 · S/N 28R-30245N3910UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842220N3910ZHudson Ollie C · Talkeetna, AKBuilt 1961 · S/N 18-7726N3911QTraining Planes LLC · Tampa, FLBuilt 1971 · S/N 17260011N3911TMartin Aviation Services LLC · Bay City, MIS/N 28R-30246N3912DPmn Enterprises LLC · Fremont, WIBuilt 1957 · S/N 34612N3912MGateway Flight Training LLC · Saint Louis, MOBuilt 1978 · S/N 28-7816385N3912NChiwaya Brandon · Philadelphia, PABuilt 1968 · S/N 680059N3912PRegistered aircraftBuilt 1978 · S/N P21000074N3912WFrankie Dixon · Cookeville, TNBuilt 1967 · S/N 32-858N3912XN3912x Holdings LLC · Sarasota, FLBuilt 1975 · S/N 28-7525337N3913TPetit Randy F Jr · Ama, LABuilt 1967 · S/N 28R-30249N3913XDesert Flight Academy Inc · Henderson, NCBuilt 1975 · S/N 28R-7535350N3914APlane Jane Aviation LLC · Sylvania, GABuilt 1970 · S/N TE-789N3914DKapowsin Air Sports Ltd · Shelton, WABuilt 1957 · S/N 34614N3914KErmis Aviation LLC · Coleman, WIBuilt 1967 · S/N 28-23782N3914MNatwick Micah E · Anchorage, AKS/N 12-2812N3914NBradford Michael G · San Jose, CABuilt 1968 · S/N 680060N3914POrtiz Fernando Mark · Squaw Valley, CAS/N 22-3584N3914QAmerican Patrol Inc · Midland, TXBuilt 1971 · S/N 17260014N3914TBias Lee · Weston, FLS/N 28R-30961N3914XLechene Aviation LLC · Indiana, PABuilt 1975 · S/N 28R-7535351N3914ZHaefeli Thomas · Del Norte, COBuilt 1961 · S/N 18-7731
Back to AD 2007-04-19 R1