Skip to content

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.

N123JHFti Group LLC · Norman, OKS/N 31P-7630010 N123LMMccleary Bryan W · Marion, OHBuilt 1967 · S/N 24-4669 N123MKSolomon Steven · Cherry Hill, NJBuilt 1965 · S/N 26-141 N123PJacobs Michael · Jay, OKBuilt 1955 · S/N 23-397 N123PVSandlapper Aviation Of De Inc · Bennington, VTBuilt 1973 · S/N 27-7305039 N123TJClover Management Systems Inc · Sanford, FLBuilt 1978 · S/N 44-7995045 N123WCLazare Luke B · Merrill, WIBuilt 1960 · S/N 22-7448 N1241CPanagiotis Markopoulos · Suffolk, VABuilt 1952 · S/N 22-1049 N1243CEndahl Eric A · Iowa City, IABuilt 1953 · S/N 22-1059 N12465Sherburn Daniel E · Spring Lake, MIBuilt 1961 · S/N 22-9057 N1247CSmith Paul J · Fremont, OHBuilt 1953 · S/N 20-968 N1248CCollier Luther Neal · Mc David, FLBuilt 1953 · S/N 22-1056 N1249VAguilar Perez Jose L · Newton, MABuilt 1976 · S/N 27-7654046 N124NREckhoff Daniel · Ramsey, MNBuilt 1960 · S/N 24-1839 N1250CBravan Aviation · Fort Lauderdale, FLS/N 31P-7530011 N1255PJones Jamie · Grants Pass, ORS/N 23-281 N12595Cornell Terry Jason · Bloomsburg, PABuilt 1971 · S/N 27-4725 N125HBKansas Farm & Ranch Inc · Seneca, KSBuilt 1978 · S/N 367860021 N125MGHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2002 · S/N 4496152 N125MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496480 N125RCChambers William M · Elkmont, ALS/N 20-615 N125YDsr-Cherokee 180 LLC · Dallas, TXBuilt 1963 · S/N 27-2366 N1261CSale Reported · Denver, COSale reportedS/N 22-1053 N1263CWidman Ralph W · Lynchburg, OHBuilt 1953 · S/N 22-1058 N1264CCoulter Clint C · Texline, TXBuilt 1953 · S/N 22-1060 N126HJPeterson Charles William · Midway City, CABuilt 1969 · S/N 24-4878 N126MAWinter Kristin A · Spring Lake Park, MNBuilt 1969 · S/N 30-1865 N126MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496481 N126PFPylant Ruth A · Lubbock, TXS/N 30-1122 N1270CSchnack Kenneth L · Crescent, IABuilt 1953 · S/N 22-1063 N1271PWendt Aero LLC · Newberg, ORBuilt 1955 · S/N 23-301 N1273PMatthews Grover C · Fairborn, OHBuilt 1955 · S/N 23-304 N127ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496035 N1280CRoesch Karl L · Arlee, MTBuilt 1953 · S/N 22-1078 N1282CSpivey Harold E · Thomaston, GABuilt 1953 · S/N 22-1076 N1283CZawada Matthew J · Roberts, MTBuilt 1953 · S/N 22-1079 N1289CGordon Robert Earl · Sanford, NCS/N 22-1110 N128ARGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2005 · S/N 4496218 N128LBWareham Andrew John · Wasilla, AKBuilt 1966 · S/N 30-1132 N128MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496171 N1292PEm Turbines Corp · Fort Lauderdale, FLS/N 23-327 N129AGMarsh Equipment LLC · Aurora, ORBuilt 2024 · S/N 4496574 N129MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496172 N12FSLawley Frederick E · Bozeman, MTBuilt 1966 · S/N 30-1226 N12GEJ&P Master Flooring Corp · Lauderdale Lakes, FLBuilt 1974 · S/N 27-7405422 N12GFStauffer Michael S · Wichita Falls, TXBuilt 1973 · S/N 31P-7300134 N12JLGiber Kristofor D · Manvel, TXBuilt 1961 · S/N 27-404 N12MPMarcus Robert L · Dallas, TXBuilt 1963 · S/N 30-284 N12PSMurphy Peter · Johns Creek, GABuilt 1981 · S/N 44-8107047 N12RDFlying Colors Airparts Inc · Leesburg, FLBuilt 1958 · S/N 24-368

Back to AD 85-02-05 R1