Registered aircraft · 69

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:2022-07-12') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-07-12') 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:2022-07-12')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-07-12')
  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:2022-07-12')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-07-12')
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.

N1127LSemper Fly Helicopters LLC · Edmond, OKBuilt 2016 · S/N 1127 N1154DFarm Fly LLC · Baxley, GABuilt 2016 · S/N 1154 N1156APleasant Aviation LLC · Mount Pleasant, TXBuilt 2016 · S/N 1156 N128YGorge Flight LLC · White Salmon, WABuilt 2016 · S/N 1128 N1368PDoan William Terry · Furlong, PABuilt 2019 · S/N 1240 N16ARBeta Fleet LLC · South Burlington, VTS/N 1412 N16DLLincoln David · Henderson, NVBuilt 2022 · S/N 1310 N207ERIndiana Helicopters LLC · Fort Wayne, INBuilt 2017 · S/N 1207 N241HBEngelmann Christopher · Mayer, MNBuilt 2019 · S/N 1241 N250CRTruflight Leasing LLC · Owasso, OKBuilt 2023 · S/N 1336 N250ZMedic Choppers LLC · Springdale, ARBuilt 2018 · S/N 1223 N25DNNorris Marvin D · Georgetown, TXBuilt 2023 · S/N 1318 N27EKPrecision Aviation Training LLC · Newberg, ORBuilt 2022 · S/N 1311 N307AKRotor Rascals LLC · Anchorage, AKBuilt 2016 · S/N 1172 N331JArndt Brent · Kodiak, AKBuilt 2023 · S/N 1331 N338CTAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2023 · S/N 1338 N354MHMission Helicopters LLC · San Diego, CABuilt 2016 · S/N 1149 N357LZAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2024 · S/N 1357 N365PARotor Leasing LLC · Indianapolis, INBuilt 2017 · S/N 1183 N366PAPureflight Aviation Training LLC · Newberg, ORBuilt 2020 · S/N 1264 N370PAMmm Equities LLC · Navasota, TXBuilt 2014 · S/N 1062 N371PABeta Fleet LLC · South Burlington, VTBuilt 2014 · S/N 1078 N39MTCorpat Inc · Missoula, MTS/N 1411 N400HG5sfcapital Holdings LLC · Newark, DEBuilt 2026 · S/N 1400 N401SHBeta Fleet LLC · South Burlington, VTBuilt 2017 · S/N 1195 N403SHAustin Peay State University · Clarksville, TNBuilt 2017 · S/N 1196 N408HCFarview Holdings LLC · San Francisco, CABuilt 2024 · S/N 1367 N4174GCaldwell Farms Inc · Garnett, KSBuilt 2024 · S/N 1374 N456PAH&H Helicopter LLC · Sauget, ILBuilt 2019 · S/N 1242 N456ZRedpole2 LLC · Kalispell, MTBuilt 2023 · S/N 1332 N457PAIdeal Aviation Illinois LLC · Sauget, ILBuilt 2019 · S/N 1247 N484EPureflight Aviation Training LLC · Newberg, ORBuilt 2023 · S/N 1321 N484JLAustin Peay State University · Clarksville, TNBuilt 2023 · S/N 1325 N503DS503 Delta Sierra LLC · Silsbee, TXBuilt 2015 · S/N 1099 N509LMClobro Media LLC · North Palm Beach, FLBuilt 2025 · S/N 1388 N51AJDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 1334 N522TFTruflight Helicopter Academy LLC · Owasso, OKBuilt 2022 · S/N 1314 N530BWWhitehead William C · Mills River, NCBuilt 2018 · S/N 1236 N54ZZNeuman Michael · Vashon, WABuilt 2023 · S/N 1337 N555RWSkyrunner Charters LLC · Colleyville, TXBuilt 2025 · S/N 1373 N612LRBravo Victor Aviation Inc · Keizer, ORBuilt 2021 · S/N 1295 N613ARHigh Plains Heli LLC · Texico, NMBuilt 2025 · S/N 1393 N655CWSt Matthew Helo LLC · Pompano Beach, FLBuilt 2023 · S/N 1335 N721TXSemper Fly Helicopters LLC · Edmond, OKBuilt 2015 · S/N 1098 N748GHummingbird Aviation LLC · Custer, SDBuilt 2023 · S/N 1319 N763SHIndiana Helicopters LLC · Fort Wayne, INBuilt 2019 · S/N 1243 N768LBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 1275 N797NAD H Helicopter Inc · Mcminnville, ORBuilt 2018 · S/N 1221 N8036XBiggs Bret · Sherwood, ORBuilt 2012 · S/N 1030 N813BTBeta Fleet LLC · South Burlington, VTBuilt 2017 · S/N 1179

Back to AD 2022-07-12