OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N114KLKaruppannan Venkatachalam · Troy, MIBuilt 1978 · S/N 14427N114LRegan Properties LLC · Coeur D Alene, IDBuilt 1997 · S/N 167N114MAAxel Aviation Inc · Roswell, GABuilt 2000 · S/N 305N114MBCrew Andrew P · Chester, CTBuilt 1976 · S/N 14084N114MGW F Carter Construction Inc · Arlington, TXBuilt 1978 · S/N 14382N114MHVlavic Aviation LLC · Hallandale Beach, FLBuilt 1979 · S/N 414A0458N114MKGood Thomas Ryan · Grapevine, TXS/N 10022-CN114MLAxis Label Inc · Hilliard, FLBuilt 2003 · S/N 0739N114MVMillin Andrew · Kalamazoo, MIBuilt 2012 · S/N 1N114NXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 44-7995289N114PCKjr3 Aviation LLC · Weatherford, TXBuilt 1975 · S/N TH-661N114PGRegional Medical · Stephentown, NYBuilt 1971 · S/N 30370N114PJRowe John J · Kansas City, MOBuilt 1982 · S/N TJ-410N114PLMaxwell Jeffreyi · Drayden, MDBuilt 1971 · S/N CE-328N114PMSundance Aviation · Morganton, NCBuilt 1999 · S/N 14666N114PSPitts S2b LLC · Salinas, CABuilt 1998 · S/N 6006N114PWSiddiqu Shahid · Hampton, VAS/N 14542N114RYoung John R · Rockland, MABuilt 1961 · S/N TE-120N114RBSjostedt Robbie J · Tehachapi, CAS/N BOWER-001N114RMImmelman Leasing Company LLC · Lompoc, CABuilt 1999 · S/N 6030N114RSLuggelle Michael · Hull, MABuilt 1966 · S/N 30-1094N114RTTerhaar Ron · Albany, ORBuilt 2001 · S/N 60046N114SCChristiansen Robert Scott · Rapid City, SDBuilt 1979 · S/N 7-2-50N114SGMixon Christopher L · Lafayette, LABuilt 1979 · S/N 14535N114SJMeashey Matthew · Wake Forest, NCBuilt 1977 · S/N 14318N114SMColvin Daniel A · Dayton, TNBuilt 1978 · S/N 14442N114SRSkymaster Stc LLC · Mena, ARS/N 14016N114SSHeritage Air LLC · Scappoose, ORS/N 14291N114TCIntegritas Forum LLC · Sundance, WYBuilt 1978 · S/N 14355N114TJKnochenmus Matthew L · Corcoran, MNBuilt 1996 · S/N 382-96N114TPGrj LLC · Lexington, SCBuilt 1975 · S/N D-9801N114TVSafi Masoud · Mckinney, TXS/N 1333N114USPeters Richard A · San Marino, CABuilt 1978 · S/N 14386N114UVUtah Vallet University · Orem, UTBuilt 2020 · S/N 40.1221N114VCStevenson Andy · Boyd, TXBuilt 1993 · S/N 14581N114VFAtticus Talon LLC · Wilmington, DEBuilt 1981 · S/N 62P08928165024N114VGN22vg LLC · Milford, NJS/N 2351N114VKKennedy Virgil C DBA · San Marcos, TXBuilt 2001 · S/N 172S8695N114VVAugust Aero LLC · Kalispell, MTBuilt 1986 · S/N 114N114WCMahan Dusty · Cookeville, TNBuilt 1976 · S/N 14126N114WEL & K Aviation Holdings LLC · Leavenworth, KSS/N 14540N114WMMaule Flight LLC · Nashville, INBuilt 2001 · S/N 25058CN114WPUniversal Aviators Academy Inc · El Monte, CABuilt 1976 · S/N 17267603N114WREstes Aviation LLC · Vicksburg, MSS/N D-10052N114XTaft Plumbing Co Inc · Taft, CABuilt 1961 · S/N 24-2698N11500Semmes James · El Centro, CABuilt 1975 · S/N 17702342N11506Fidk Inc · Warrenton, VABuilt 1975 · S/N 17702343N1150AMountain Air Spray Company · Craig, COBuilt 1951 · S/N 18-744N1150JAircruz LLC · Maumelle, ARBuilt 1974 · S/N 150N1150PGiermek Peter T · Olean, NYBuilt 1955 · S/N 23-163
Back to AD 2007-04-19 R1