Skip to content

Registered aircraft · 240

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

N101HJCore Group Transport LLC · Jackson, MSBuilt 2019 · S/N 42000139 N101JTSiracusano Aviation Services LLC · Naperville, ILBuilt 2018 · S/N 42000130 N103HJRegistration Pending · Baton Rouge, LARegistration pendingBuilt 2019 · S/N 42000162 N103JTHenderon Jet Services LLC · Georgetown, TXBuilt 2019 · S/N 42000163 N104HJMile High Club Aviation LLC · Mentor, OHBuilt 2018 · S/N 42000104 N107CXTempest Aviation LLC · Dover, DEBuilt 2022 · S/N 42000230 N1100HRio Grande Pacific Corporation · Benbrook, TXBuilt 2018 · S/N 42000110 N110HJGw Matthews Aviation LLC · Dover, DEBuilt 2016 · S/N 42000020 N111DTriple Delta LLC · New Orleans, LABuilt 2023 · S/N 42000246 N113HXHappytimes Aviation LLC · New Albany, OHBuilt 2018 · S/N 42000126 N118CXAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2022 · S/N 42000231 N1190RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 42000220 N120GEGeneral Electric Co · Cincinnati, OHBuilt 2018 · S/N 42000129 N120GFGolden Aviation LLC · Golden, COBuilt 2022 · S/N 42000232 N120HFGeneral Electric Co · Cincinnati, OHBuilt 2017 · S/N 42000050 N120KAOdin 123 LLC · Fort Lauderdale, FLBuilt 2018 · S/N 42000120 N121HJThomas Karen P · Las Vegas, NVBuilt 2024 · S/N 42000261 N1224AEfn 63 LLC · Sugar Grove, ILBuilt 2018 · S/N 42000131 N123PMPipe In The Sky Aviation LLC · Houston, TXBuilt 2018 · S/N 42000123 N124HJCar Pros LLC · Natchez, MSBuilt 2018 · S/N 42000124 N124LSChristian Fellowship Church Inc · Prescott, AZBuilt 2023 · S/N 42000243 N125CXBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 42000234 N12DCRuston Aviation LLC · Tulsa, OKBuilt 2019 · S/N 42000144 N135CXValiair Limited Company Trustee · Casper, WYBuilt 2022 · S/N 42000237 N137JTBbme Ventures LLC · Incline Village, NVBuilt 2019 · S/N 42000178 N13ZMReaching Disaster Victims Worldwide LLC · Maitland, FLBuilt 2017 · S/N 42000057 N143RPWdfc Partners LLC · York, PABuilt 2019 · S/N 42000143 N143TRStamper Family LLC · Scottsdale, AZBuilt 2020 · S/N 42000190 N147CXMntex Air LLC · Glencoe, MNBuilt 2022 · S/N 42000239 N14QBBas Part Sales LLC · Greeley, COBuilt 2018 · S/N 42000107 N14VSVeruca Salt LLC · Washington, TXBuilt 2023 · S/N 42000249 N151JMN258wt LLC · Boca Raton, FLBuilt 2024 · S/N 42000269 N166HJW & J Trucking LLC · Mandeville, LABuilt 2017 · S/N 42000066 N167HJLangtree Aero LLC · Wilmington, DEBuilt 2019 · S/N 42000167 N168HJGrilled Oysters Inc · Gulf Shores, ALBuilt 2019 · S/N 42000168 N17HJAndre Smith Aviation LLC · Baton Rouge, LABuilt 2018 · S/N 42000128 N184HJTpc Aviation LLC · Saint Louis, MOBuilt 2020 · S/N 42000184 N18ZHAbove The Clouds LLC · Helena, MTS/N 42000054 N191WSAbstract Aviation Inc · Clearwater, FLBuilt 2019 · S/N 42000155 N192WSTempest Aviation LLC · Dover, DEBuilt 2019 · S/N 42000156 N193WSMach 806 LLC · Wilmington, DEBuilt 2019 · S/N 42000160 N199HJHj Equipment LLC · Gulf Breeze, FLBuilt 2020 · S/N 42000183 N199WSElite Aviation 193 LLC · Deerfield Beach, FLBuilt 2020 · S/N 42000193 N19JYOxford Advisory Aviation LLC · Orlando, FLBuilt 2017 · S/N 42000072 N19THonda Aviation Service Co Inc · Greensboro, NCS/N 42000294 N1EKLuca 2 Leasing LLC · Sarasota, FLBuilt 2023 · S/N 42000242 N1RJJackson Executive Transport LLC · Jackson, MIBuilt 2018 · S/N 42000109 N1RZRefzero Aviation LLC · Monument, COBuilt 2024 · S/N 42000268 N20UQMax Foote Construction Co LLC · Mandeville, LABuilt 2017 · S/N 42000048 N211PJHonda Aviation Service Co Inc · Greensboro, NCBuilt 2020 · S/N 42000181

Back to AD 2018-21-13