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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N138BRElk River Consulting Inc · Fayetteville, TNBuilt 1992 · S/N 1528 N138EZToelaer John C · Madison, ALBuilt 1995 · S/N 138 N138FCUsda Forest Service Fepp · Tallahassee, FLBuilt 1982 · S/N 28-8290102 N138FRAyotte Matthew A · South Haven, MIBuilt 1986 · S/N 17276545 N138GBBurgan Grover W · Jacksonville, FLBuilt 2005 · S/N 473-2005 N138JPChang Denny · Easton, PABuilt 1970 · S/N 17701442 N138MEA&R Aero LLC · Sacramento, CABuilt 2000 · S/N 172S8422 N138RJBayou Flight Training LLC · Niceville, FLBuilt 1988 · S/N 821 N138SFUnderwood Mark A · Kennewick, WAS/N 28-20998 N138TPTwo Pauls LLC · Forked River, NJBuilt 1968 · S/N 28-25301 N13902Campbell Travis G · Starr, SCBuilt 1974 · S/N 17263035 N13905Positive Rate LLC · Rutherford, NJBuilt 1974 · S/N 17263036 N1390RYancy Timothy J · Chino Hills, CABuilt 1975 · S/N AA5-0790 N13910Coryell James M · Valdez, AKBuilt 1974 · S/N 18-7409055 N13911Northern Aeroworks LLC · Eagle River, AKBuilt 1971 · S/N 18-8972 N1391RMccarthy Daniel J · San Diego, CAS/N AA5-0791 N1391UArctic Winds Inc · King Salmon, AKS/N 17267062 N13923Timoszyk James S · Wayne, MIBuilt 1974 · S/N 17263039 N13925Lindsay John S · Freeport, PABuilt 1971 · S/N 18-8973 N13927Zerck Joseph W · Anchorage, AKBuilt 1972 · S/N 18-8977 N1392WSale Reported · Lakeland, FLSale reportedBuilt 1964 · S/N 2670 N13931Mahoney Edmund Mont · Anchorage, AKBuilt 1972 · S/N 18-8978 N13937Rafter J Aviation LLC · Moab, UTS/N 18-8979 N13938Seattle Offshore Dmi Inc · Bothell, WAS/N 17263041 N13939Diessner Daniel J · New Smyrna Beach, FLBuilt 1976 · S/N 17702477 N1393EMossler Jonathan E · Edgewater, FLBuilt 1978 · S/N 17270983 N1393PSeymour Lori L · Woodstock, GAS/N 23-445 N1393USelim Shahir P · Hollywood, FLBuilt 1976 · S/N 17267064 N13941Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263044 N13942Rohrer Mary · Fredericksburg, TXBuilt 1974 · S/N 17263045 N13943Tell Christopher A · Colville, WAS/N 17263046 N13944Ripp Ted · Pulaski, TNBuilt 1974 · S/N 17263047 N13946Air Capital Aviators Club · Wichita, KSBuilt 1974 · S/N 17263048 N1394WLuniewicz Morgan · Walnutport, PAFirst renewal noticeS/N 2672 N13951Black Timber Aviation LLC · Rifle, COBuilt 1972 · S/N 18-8981 N1395FMoquin Christopher · Chicago, ILS/N 578 38 8392 N1395RKing Rodney R · Lucedale, MSBuilt 1975 · S/N AA5-0795 N1395UBentley Robert H · Lockport, ILBuilt 1976 · S/N 17267066 N1395WRienstra Andrew P · South Lyon, MIBuilt 1964 · S/N 2673 N13960John Mark Air Repair LLC · Chugiak, AKBuilt 1972 · S/N 18-8984 N1396RHodges John J · Cleburne, TXBuilt 1975 · S/N AA5-0796 N1396WD & J Solutions Inc · Nokesville, VABuilt 1964 · S/N 2674 N13973Rs Specialties LLC · Anchorage, AKBuilt 1972 · S/N 18-8985 N1397URock Solid Aviation LLC · Lake Charles, LABuilt 1976 · S/N 17267068 N1397WMorris Michael E · Las Vegas, NVBuilt 1964 · S/N 2675 N1398CBennett Eric · Warsaw, INBuilt 1977 · S/N 17702720 N1398EMichael Elan · Encino, CABuilt 1978 · S/N 17270985 N1398HMiller Debra L · Anchorage, AKS/N 15AC-449 N1398PWolbert Valerie M · Canton, GABuilt 1956 · S/N 23-449 N1398RHopland Steven R · Johnson City, TNBuilt 1975 · S/N AA5-0798

Back to AD 80-04-03 R2