Registered aircraft · 6,349

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-25-02-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-25-02-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-25-02-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-25-02-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-25-02-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-25-02-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.

N818TSlipstream Aviation LLC · Carrollton, GAS/N 15283216 N81DNWaite John B · Tacoma, WABuilt 1997 · S/N 756 N81EJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1989 · S/N 001 N81ESBranciforte Louis N · Watsonville, CABuilt 1987 · S/N 1894 N81HSHarris David C · Ventura, CAS/N 001 N81JGGreaves Jr John P · Redding, CABuilt 1984 · S/N 1478 N81JVVoss James S · Boulder, COBuilt 1994 · S/N 1 N82023Rodriguez Richard V · Brooklyn, NYBuilt 1992 · S/N 2216 N8206BSandoval Joel · San Luis, AZS/N 2723 N82092Olsen Kyle · Girdwood, AKBuilt 1990 · S/N 1522 N82093Oborny Alan R · Choteau, MTBuilt 1946 · S/N 7AC-719 N821RPVan Cleave Raymond D · Kalispell, MTBuilt 1997 · S/N 92948 N82286Registration Pending · Bullhead City, AZRegistration pendingBuilt 1946 · S/N 7AC-915 N822DJCoscio David V · Kings Beach, CABuilt 2025 · S/N 77 N822PJNeary Michael John · Tuckerton, NJBuilt 1979 · S/N WA-47 N822REEaton Ray · Zeeland, MIBuilt 1964 · S/N 22-9802 N822VAffection Above Aviation Inc · Yukon, OKBuilt 1978 · S/N 1281-79 N82512Reed Charles H · Shelbyville, KYBuilt 1946 · S/N 7AC-1149 N825MCC & M Aviation LLC · White Lake, MIBuilt 1976 · S/N 1154-76 N82603Spain Benjamin D · Opelika, ALBuilt 1946 · S/N 7AC-1240 N82604Graves Frank C · Nocona, TXBuilt 1946 · S/N 7AC-1241 N82682Long Jory J · Lake Ozark, MOBuilt 1970 · S/N 772-70 N826VACrop Care By Air Inc · Lantry, SDS/N 12-3012 N828HPParsons Harry · Bloomfield, NJBuilt 1986 · S/N 898 N82973Midland Avionics LLC · Louisville, KYBuilt 1946 · S/N 7AC-1625 N8298Cochran Brent D · Sandy Valley, NVBuilt 1975 · S/N 017 N829BBaxter Thomas L · Stockbridge, GABuilt 1950 · S/N 6760 N82LMMartindale Harold L · Orange, TXBuilt 1984 · S/N 1215 N82VBSky Designs LLC · Kalamazoo, MIBuilt 1967 · S/N 491 N8302VStrange Beasts LLC · Chicago, ILBuilt 1966 · S/N 414 N8306VJones Richard E · Cody, WYBuilt 1966 · S/N 244 N8307VFowler Steve · Washington, INS/N 465 N8312VPester Mark C · Crookston, MNBuilt 1966 · S/N 458 N8313VMedlin Wayne D · Marshville, NCBuilt 1966 · S/N 53 N8315VReynolds Eric F · Princeton, MNBuilt 1966 · S/N 481 N8317VLynch Gerald C · Collinsville, OKBuilt 1966 · S/N 84 N831GBDievendorf Gerry T · Columbia, SCS/N 284 N8323VToczek Keith E · Yankton, SDS/N 55 N8324WSwofford Sherman A · Inman, SCBuilt 1965 · S/N 28-2501 N8331VAirplane Binnis LLC · Janesville, WIBuilt 1966 · S/N 477 N8334VRegistration Pending · Milton, FLRegistration pendingBuilt 1966 · S/N 482 N8335VLisoski Derek L · Clark Fork, IDBuilt 1966 · S/N 474 N8337VWydronek Joseph A · Tucson, AZBuilt 1966 · S/N 422 N8338VGustafson Cody A · Corvallis, ORBuilt 1966 · S/N 401 N8342VPrecision Aerial Ag LLC · Seneca, KSS/N 232 N834GTIlmberger Stephen R · Sisters, ORBuilt 1981 · S/N 15285111 N8350VMertz Rachel A · New Ulm, MNFirst renewal noticeBuilt 1966 · S/N 85 N8353VN8353v LLC · Monroe, LAS/N 294 N8356VGroh David A · Mason, MIBuilt 1966 · S/N 478 N8359VCressman Scott M · Mount Pleasant, TXBuilt 1966 · S/N 412

Back to AD 80-25-02 R2