OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,472

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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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.

N1673EHusband Thomas W · Bigfork, MTBuilt 1978 · S/N 17271090N1673JSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1967 · S/N 28-24074N1674JCaloon John H · Greenfield, MABuilt 1968 · S/N 28-24075N1674VAbraham Elizabeth J · Browntown, WIBuilt 1974 · S/N 17263709N1675HIcarus Flying Academy LLC · Farmingdale, NYBuilt 1977 · S/N 28-7716040N1675JTevis Aviation Inc · Emporia, KSBuilt 1967 · S/N 28-24076N1677JCross X Country LLC · Great Falls, VABuilt 1968 · S/N 28-24078N1678HBrown Gregory B · New London, CTBuilt 1977 · S/N 28-7790330N1678JCloudhoppers Inc · Effingham, ILBuilt 1967 · S/N 28-24079N1679PClearwater Potlatch Timber Pa · Orofino, IDBuilt 1954 · S/N 18-4068N167AMVandeventer Larry D · Charlotte, NCBuilt 1999 · S/N 23163N167BWMartin Jennifer · Palm Desert, CABuilt 1974 · S/N 12475N167CSBalister Adrian G · Colorado Springs, COS/N 23197N167GTPreferred Procurement LLC · Sheridan, WYBuilt 2001 · S/N 2007N167LDRegistered aircraftS/N 670105N167MSMullinax Robert A · Toccoa, GABuilt 1993 · S/N 2105N167PCBlue Mountain Flyers Inc · Palmerton, PABuilt 2003 · S/N 1349-2003N167RMSellman Richard · Chadron, NEBuilt 1967 · S/N 18-8514N167TCFarzaneh-Far Ramin · Brookline, MABuilt 2001 · S/N 1304-2000N1680APaprocki Jason C · Fairplay, COS/N 20-842N1681PWarner Philip · San Marcos, CABuilt 1954 · S/N 22-2467N1682JBeatty Gary A · Mosinee, WIFirst renewal noticeBuilt 1967 · S/N 28-24083N1683JMiranda Emigdio · El Dorado Hills, CAS/N 28-24084N1684JJarriel Investments Inc · Register, GABuilt 1967 · S/N 28-24086N1685Lane Aviation LLC · Tijeras, NMBuilt 2008 · S/N 030-53/54-704N1685GBrisson Gisele A · Hollister, CABuilt 1968 · S/N 194N1685PMckinney Derrill L · Rio Linda, CABuilt 1954 · S/N 22-2471N1686ELiddick Terry S · Spearfish, SDBuilt 1978 · S/N 17271093N1686JPatterson John E · Jacksonville, ILBuilt 1967 · S/N 28-24088N1687GSimon Mitchell B · Edison, NJFirst renewal noticeS/N 196N1687JMarsh Flyers LLC · Britton, SDBuilt 1968 · S/N 28-24089N1687PSofia De Venecia LLC · Southampton, NYBuilt 1954 · S/N 22-2473N1688ERegistered aircraftFirst renewal noticeBuilt 1978 · S/N 17271095N1688JTalley Charles B · Ignacio, COS/N 28-24091N1688TCape May Aero LLC · Cape May, NJBuilt 1970 · S/N 28-7125005N1688VAvstem Incorporated · Mc Grath, AKBuilt 1974 · S/N 17263714N1689JHouff Christopher J · Mount Crawford, VABuilt 1968 · S/N 28-24092N1689TFun Flyers LLC · Rapid City, SDBuilt 1970 · S/N 28-7125006N168ABerry James N · Abilene, TXBuilt 2001 · S/N JC8N168ALWittman Matthew · New York, NYBuilt 2000 · S/N 60168N168DMarolf Duke · Seward, AKBuilt 1963 · S/N 18-8293N168DDIndian Beach Aviation LLC · Clayton, NCBuilt 2003 · S/N 23811N168DPJohnson Eldridge Jr · Chicago, ILBuilt 1967 · S/N 28-4402N168KWWalsh Home Improvement Co Inc · Berlin, MDBuilt 1972 · S/N 28-7305031N168RGray Jim E · Punta Gorda, FLBuilt 1986 · S/N 168N168XBook Paul A · Richvale, CAS/N JC7N1690PPritchett Michael L · Benton, ARS/N 22-2476N1690THutchison Harry L · Grandview, MOS/N 28-7125007N1691GPalmer Christopher John · Upper Lake, CABuilt 1968 · S/N 134N1691JBaldwin Rickey Albert · Clarksville, VAS/N 28-24094
Back to AD 80-04-03 R2