Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N12TASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 22-6319 N1300CSelf James M · Fennville, MIBuilt 1953 · S/N 22-1102 N1301CPiper Aviation Museum Foundation · Lock Haven, PABuilt 1953 · S/N 22-1095 N1303CRodriguez Isaac J · Fort Smith, ARS/N 22-1098 N1305PParkhill Clifton A Jr Trustee · Oxnard, CABuilt 1955 · S/N 23-345 N1308BHopewell Jeffrey D · Temple, TXBuilt 1955 · S/N 23-340 N1308CHahn Aviation Inc · Troy, OHBuilt 1953 · S/N 22-1112 N130AGWings Over Texas Holdings LLC · Denton, TXBuilt 2024 · S/N 4496578 N130MMMighty Mike LLC · Maysville, KYBuilt 1964 · S/N 30-550 N130MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2019 · S/N 4496477 N1312CApplegate Paul H · Queen City, MOBuilt 1953 · S/N 22-1104 N1316PMatthews Grover C · Hardinsburg, KYBuilt 1955 · S/N 23-356 N1317PWhite Christopher N · Clearwater, FLBuilt 1955 · S/N 23-357 N1319PCanter Russell L · Enterprise, KSBuilt 1955 · S/N 23-360 N131ABPlane And Simple Leasing LLC · Delano, MNBuilt 1965 · S/N 25-3693 N131AGWings Over Texas Holdings LLC · Denton, TXBuilt 2024 · S/N 4496589 N131FAJones Donald T Jr · Barrigada, GUBuilt 1968 · S/N 27-4097 N131MPN Registration Service LLC Trustee · Sanford, NCS/N 31P-7400193 N131RMInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 27-7654053 N131TVO'Brien Daniel H · Half Moon Bay, CABuilt 1977 · S/N 27-7754070 N1320CToney Tasha Fay · Lafayette, INS/N 22-1116 N1324CLawrence Mark J · Rouses Point, NYS/N 22-1131 N1329CHughes Steve D · Ellsworth, WIBuilt 1953 · S/N 22-1119 N132AGMarsh Equipment LLC · Aurora, ORBuilt 2024 · S/N 4496590 N132CTausch Roger M · Saint Charles, MIBuilt 1963 · S/N 30-62 N132DWChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 4496139 N132MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2022 · S/N 4496540 N1334PN1334p LLC · Titusville, FLBuilt 1955 · S/N 23-379 N1335CDorn Kevin J · De Pere, WIBuilt 1953 · S/N 22-1136 N1335PRiggin Flight Service Inc · Madison, SDS/N 23-380 N1339CWalt'S Kustom Kreations Inc · Palatka, FLBuilt 1953 · S/N 22-1135 N133FKing Tyler B · Saint Stephen, SCBuilt 1956 · S/N 22-4023 N1342CLink James R · Moses Lake, WABuilt 1953 · S/N 20-977 N1343CNimer David K · Malad City, IDS/N 22-1142 N1344CCreasy Frank E · Suffolk, VABuilt 1953 · S/N 22-1144 N1344PCrist Charles E · Waxahachie, TXBuilt 1955 · S/N 23-390 N1346CWorden Gail · Burt, MIS/N 22-1145 N134DWAtp Aircraft 1 LLC · Wilmington, DES/N 4496167 N134FSAlcione LLC · Miami, FLBuilt 1978 · S/N 27-7854117 N134MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496483 N134MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2024 · S/N 4496593 N1352PHouse Travis · Bristow, VABuilt 1955 · S/N 23-401 N135MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2024 · S/N 4496594 N135UInter American University Of Puerto Rico · Bayamon, PRBuilt 1997 · S/N 4496015 N1367PBuzzard Air Service LLC · Carleton, MIBuilt 1956 · S/N 23-416 N136DWSun Aircraft Management LLC · Ormond Beach, FLBuilt 2003 · S/N 4496168 N136JMGregory Warren D Jr · Aguila, AZBuilt 1963 · S/N 22-5557 N136YJanoski David M · Fort Worth, TXBuilt 1960 · S/N 24-1991 N13760Chiniewicz Michael · The Colony, TXBuilt 1969 · S/N 27-4409 N13803Crociati Douglas R · Plymouth, MABuilt 1969 · S/N 27-4448

Back to AD 85-02-05 R1