Registered aircraft · 25,370

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-07-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:80-25-07-R1') 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-07-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:80-25-07-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.

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-07-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:80-25-07-R1')
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.

N53368Arnt Aerial Spraying Inc · Worthington, MNBuilt 1974 · S/N 18801790 N5336DFerguson Bart M · Argyle, TXBuilt 1979 · S/N 17272525 N5336KSharpes Daniel G · Albuquerque, NMBuilt 1980 · S/N 17274069 N5336YBlue Sky Inc · Lone Rock, IAS/N 21064170 N53371Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17274733 N53373Bemidji Aviation Services Inc · Bemidji, MNS/N 17274734 N5337LFather Son Ing LLC · Wilmington, DEBuilt 1980 · S/N 15284296 N5337PHanson David J · Elgin, TXBuilt 1981 · S/N 15284920 N5337YClement Aviation Inc · Tea, SDBuilt 1980 · S/N 21064171 N53380Haltom Gary D · Alva, OKS/N 15283540 N53387Reifsnyder Daniel S · Lewistown, PABuilt 1981 · S/N 17274738 N5338AThompson Richard T · Wilmington, OHBuilt 1979 · S/N 21063376 N5338UWatermelon Packer Ll · Mcallen, TXBuilt 1984 · S/N 21064871 N5338VMassie Patrick J · Friendswood, TXBuilt 1980 · S/N 172RG0509 N53391Schwend Brian · Forsyth, MTBuilt 1974 · S/N 18801805T N5339BFiebig Howard J · Sebewaing, MIBuilt 1979 · S/N 15283841 N5339DTang Hong-Ming · San Dimas, CABuilt 1979 · S/N 17272528 N5339HBering Capital LLC · Anchorage, AKBuilt 1975 · S/N 17265407 N5339KNordell Kent D · Staples, MNBuilt 1980 · S/N 17274071 N533SJLns LLC · Wichita, KSBuilt 1978 · S/N 17271533 N53402Anvab Inc DBA · Concord, NHBuilt 1981 · S/N 17274743 N5340WHebel Ryan · North Potomac, MDBuilt 1981 · S/N P21000675 N5340YCripe Michael L · San Luis Obispo, CABuilt 1980 · S/N 21064173 N5341HHoffman Calhoun E · Barnwell, SCBuilt 1975 · S/N 17265408 N5342DCornell Timothy R · Hartland, WIS/N 17272531 N5342PSp Airparts LLC · Moscow, IDBuilt 1981 · S/N 15284921 N53437Vineyard Eddie E · Wapello, IABuilt 1981 · S/N 17274749 N5343SRayham LLC · Oxford, GABuilt 1980 · S/N R18201549 N5344BJohn Annin LLC · Fenton, MOBuilt 1979 · S/N 15283843 N5344DAirgo Inc · Centralia, ILBuilt 1979 · S/N 17272532 N5344HA&F Aviation Services LLC · Collierville, TNBuilt 1975 · S/N 17265409 N5344KBoeing Employees Flying Assoc · Renton, WABuilt 1980 · S/N 17274074 N5344MPinger Kevin R · Palo Alto, CABuilt 1980 · S/N 15284548 N53456Amelia Reid Aviation LLC · San Jose, CABuilt 1981 · S/N 17274754 N5345MNew Orleans Aerial Tours & Flight Training LLC · New Orleans, LABuilt 1980 · S/N 15284549 N53463Fara Nick · San Anselmo, CABuilt 1981 · S/N 17274758 N5346DBoldflight LLC · Greenwood, INBuilt 1979 · S/N 17272534 N5346EOsprey Holding Company LLC · Foley, ALBuilt 1977 · S/N 17269573 N5346KUsaeroflight LLC · Greenville, SCS/N 17274075 N5346VRegistered aircraftBuilt 1980 · S/N 172RG0510 N5347HMonterey Bay Aviation Inc · Watsonville, CABuilt 1975 · S/N 17265410 N5348BBowers Curt E · Jennings, LABuilt 1979 · S/N 15283844 N5348DSwaz Aviation LLC · Mesa, AZBuilt 1979 · S/N 17272536 N5348UC3 Shadow LLC · Columbus, OHBuilt 1984 · S/N 21064874 N5348VKavon Clinreg LLC · Palm Beach Gardens, FLBuilt 1980 · S/N 172RG0511 N5348YWheeler Robert T · Silt, COBuilt 1980 · S/N 21064176 N53491Crossbrook LLC · Willoughby, OHBuilt 1981 · S/N 17274764 N53494Gandarillas Andrew J · Toledo, WABuilt 1981 · S/N 17274765 N5349DFisher Randall A · Salem, OHBuilt 1979 · S/N 17272537 N534DWValiair Ltd Co Trustee · Casper, WYBuilt 1976 · S/N 177RG1004

Back to AD 80-25-07 R1