OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,471

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.

N9732DTouzeau Raymond V · Newberg, ORS/N 22-6644N9732HLand & Leave LLC · Helena, MTBuilt 1975 · S/N 17266340N9732JWalborn Gary D · Youngstown, OHBuilt 1967 · S/N 28-3925N9732VSiguaw Robert E · Deming, WABuilt 1974 · S/N 17264496N9732WFlying Elvis · Jacksonville, FLBuilt 1967 · S/N 28-23212N9733DMcfalls Caleb Parker · York, SCBuilt 1959 · S/N 22-6645N9733LStock Craig A · Devon, PABuilt 1986 · S/N 17276604N9733VTyler Ronald J · Martville, NYBuilt 1974 · S/N 17264497N9733WWilson Lyndon K Sr · Ringgold, GAS/N 28-23214N9734BPreston Aviation LLC · Henderson, KYBuilt 1981 · S/N 172RG0999N9734JPiper Perfect LLC · Panama City, FLBuilt 1967 · S/N 28-3927N9734PHornyak Ryan J · Girard, PABuilt 1975 · S/N 18-7609008N9734USls Aviation LLC · Poquoson, VABuilt 1976 · S/N AA5A-0134N9734WNimbus Air LLC · Frankfort, ILS/N 28-23215N97358Rick Aviation Inc · Newport News, VABuilt 1984 · S/N 17276180N9735DSkinner Timothy G · Archer, FLS/N 22-6647N9735PSprenger Mark R · Eagle River, AKBuilt 1975 · S/N 18-7609009N9735UFreeman George W · Wolcottville, INBuilt 1976 · S/N AA5A-0135N9736DCamp Doug A · Starkville, MSBuilt 1959 · S/N 22-6648N9737DFolkvord Darrel L · Toston, MTS/N 22-6649N9737LSzish Michael · Mountain Top, PABuilt 1972 · S/N MB-524N9737VAero Equities LLC · Ventura, CABuilt 1975 · S/N 17264499N9737WAzzurra City Tours LLC · Staten Island, NYBuilt 1967 · S/N 28-23219N9738MVurlumis George A · Pocono Lake, PABuilt 1967 · S/N 670032N9738WBendigo Paul L · Reading, PABuilt 1967 · S/N 28-23220N9739JSullins Drew Preston · Woodstock, MDBuilt 1967 · S/N 28-3933N973TMAnders Andrew C · Lansdale, PABuilt 1972 · S/N 28-7205254N9740DSchilling Michael · Nikiski, AKFirst renewal noticeBuilt 1959 · S/N 22-6653N9740JSpasiano Kyle P · Camarillo, CABuilt 1967 · S/N 28-3934N9740WD14 Flight Club Inc · Manteno, ILBuilt 1967 · S/N 28-23222N9741JSchulte Lance D · East Dundee, ILBuilt 1967 · S/N 28-3936N9741MPeterson Bradley A · Savoy, ILBuilt 1967 · S/N 670035N97428Right Wing Aviation LLC · Fort Wayne, INBuilt 1984 · S/N 17276188N9742DJones Adam J · Lucerne Valley, CABuilt 1959 · S/N 22-6655N9742JBores Scott J · Huron, OHS/N 28-3937N9742MCastro Laura · Phoenix, AZBuilt 1967 · S/N 670036N9742QMese Jacob L · Savannah, GABuilt 1971 · S/N M-1313N9742WThurmond Donald · Madison, GAS/N 28-23224N9743BVinson Paul E DBA · Gainesville, GABuilt 1981 · S/N 172RG1006N9743JMcmurry Patric R · Casper, WYBuilt 1967 · S/N 28-3939N9743LSundowner Rental Options LLC · Lawrenceville, GABuilt 1971 · S/N M-1371N9743MAdney William J · Woodville, TXS/N 670037N9743WFoster Jay W · Marshfield, MOBuilt 1967 · S/N 28-23225N9744JMerrick Christina L · Sylmar, CABuilt 1967 · S/N 28-3940N9744M44 Mike LLC · Highlands Ranch, COS/N 670038N9744QLong Richard · Sebastopol, CABuilt 1970 · S/N M-1314N9744UPilot Farm LLC · Grant, NEBuilt 1976 · S/N AA5A-0144N97459Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 17276190N9745CWashington State Community College District 17 · Spokane, WABuilt 1978 · S/N 28-7816523N9745JLakeview Aviation LLC · Great Barrington, MABuilt 1967 · S/N 28-3941
Back to AD 80-04-03 R2