Registered aircraft · 189

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

N110DMColville Holding LLC · Anchorage, AKBuilt 2023 · S/N 4698265 N113HKHawkeyesky LLC · Sheldon, IABuilt 2019 · S/N 4698113 N117PRQualitair LLC Trustee · MichelstadtBuilt 2019 · S/N 4698117 N131AAAery Aviation LLC · Newport News, VABuilt 2019 · S/N 4698118 N131HLBas Part Sales LLC · Greeley, COS/N 4698131 N140PPN560hp LLC · Del Mar, CABuilt 2020 · S/N 4698140 N146PMRegistered aircraftBuilt 2020 · S/N 4698146 N157STAllen Family Aviation LLC · Haines, ORBuilt 2023 · S/N 4698280 N163GTDoedoe Aviation LLC · Dalhart, TXBuilt 2018 · S/N 4698095 N163HLSkywood Aviation LLC · Wayne, NJBuilt 2021 · S/N 4698163 N164TPZ Axis Aviation LLC · Hyde Park, UTBuilt 2021 · S/N 4698164 N187KN187k LLC · Houston, TXBuilt 2021 · S/N 4698186 N207WWDarling'S Agency LLC · Brewer, MEBuilt 2023 · S/N 4698287 N208MAGriffin Construction Co · Fort Smith, ARBuilt 2018 · S/N 4698075 N219PWProfessional Wash And Detail LLC · Colorado City, AZBuilt 2016 · S/N 4698010 N224LMN569st Leasing LLC · Sarasota, FLBuilt 2020 · S/N 4698153 N230PM889ma LLC · Clinton, MSBuilt 2022 · S/N 4698212 N231DNHenrys Investments LLC · Encinitas, CABuilt 2022 · S/N 4698211 N241LGHorak David · El Paso, TXS/N 4698156 N246WANimativ Aviation LLC · Palm Coast, FLBuilt 2023 · S/N 4698246 N247LLFinco Luca · Chicago, ILBuilt 2021 · S/N 4698192 N24CWNewton Park Partners LLC · Apalachicola, FLS/N 4698227 N24RJN24rj LLC · New Port Richey, FLBuilt 2017 · S/N 4698028 N25WZCoreman LLC · Tampa, FLBuilt 2022 · S/N 4698234 N267STJb Aviation LLC · New Brighton, PABuilt 2023 · S/N 4698267 N26EMKp Interests LLC · Missoula, MTBuilt 2018 · S/N 4698081 N271ZRegistration Pending · Helena, MTRegistration pendingBuilt 2023 · S/N 4698271 N274KTVictor 1 LLC · Logan, UTBuilt 2017 · S/N 4698036 N274MPiper Aircraft Inc · Vero Beach, FLS/N 4698297 N274WAGosch Development LLC · Heber City, UTBuilt 2019 · S/N 4698103 N276TPBarden And Barden Holdings LLC · Canton, GABuilt 2023 · S/N 4698276 N277KWHolmes William F · Diberville, MSBuilt 2022 · S/N 4698187 N27WRBrew Air LLC · Macon, GABuilt 2022 · S/N 4698204 N285KCCourt Reporter Assignments Inc · Bullhead City, AZBuilt 2023 · S/N 4698285 N28WESummit Aviation LLC · Aberdeen, SDBuilt 2017 · S/N 4698035 N291STAl-Secky LLC · New York, NYBuilt 2022 · S/N 4698219 N2924RSt Flight Ops LLC · Camarillo, CABuilt 2022 · S/N 4698202 N305HMFast On The Hunt LLC · Ponca City, OKBuilt 2019 · S/N 4698101 N30BEEllingson Craig Edward Trustee · Clive, IABuilt 2021 · S/N 4698194 N311MXInternational Air Services Inc Trustee · Carson City, NVBuilt 2022 · S/N 4698213 N316MPTurbine Ag Holdings LLC · Cross Plains, WIBuilt 2018 · S/N 4698085 N322MTSkyak LLC · Chanhassen, MNBuilt 2022 · S/N 4698237 N322WWWest Aviation LLC · Palm City, FLBuilt 2020 · S/N 4698133 N324PKMichiana Holdings LLC · Miami Beach, FLBuilt 2018 · S/N 4698074 N325PWWatson 321 Air LLC · Flower Mound, TXBuilt 2023 · S/N 4698273 N325STKnollwood Navigation LLC · Hunt Valley, MDS/N 4698138 N330MAVenture Acquisition Holdings LLC · Johnstown, OHBuilt 2020 · S/N 4698145 N334TC4d Journey LLC · Prattsville, NYBuilt 2023 · S/N 4698259 N337TCSpinley Publishing LLC · Lewes, DEBuilt 2016 · S/N 4698024 N33HGMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2022 · S/N 4698200

Back to AD 2017-16-03