Skip to content

Registered aircraft · 967

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-07-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-07-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-07-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-07-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-07-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-07-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.

N532JM31 Pine Street LLC · Moorpark, CABuilt 2023 · S/N 680A0370 N532QSRegistered aircraftBuilt 2017 · S/N 680A0073 N532SMSetzer Murry LLC · Lexington, KYBuilt 2005 · S/N 680-0017 N533QSRegistered aircraftBuilt 2017 · S/N 680A0074 N5346MAlliance Laundry Systems LLC · Ripon, WIBuilt 2010 · S/N 680-0292 N534QSRegistered aircraftBuilt 2022 · S/N 680A0315 N535QSRegistered aircraftBuilt 2017 · S/N 680A0078 N536QSRegistered aircraftBuilt 2017 · S/N 680A0079 N537QSRegistered aircraftBuilt 2017 · S/N 680A0087 N538QSRegistered aircraftBuilt 2017 · S/N 680A0081 N539QSRegistered aircraftBuilt 2017 · S/N 680A0082 N540PLWest End 65 LLC · Savannah, GABuilt 2020 · S/N 680-0594 N540QSRegistered aircraftBuilt 2017 · S/N 680A0083 N541QSRegistered aircraftBuilt 2017 · S/N 680A0084 N542QSRegistered aircraftBuilt 2017 · S/N 680A0091 N543QSRegistered aircraftBuilt 2017 · S/N 680A0092 N544JBAvalanche Air LLC · Houston, TXBuilt 2010 · S/N 510-0353 N544QSRegistered aircraftBuilt 2017 · S/N 680A0093 N545CMIrrg LLC · Kane, PABuilt 2015 · S/N 510-0460 N545QSRegistered aircraftBuilt 2017 · S/N 680A0095 N545SStark Aircraft LLC · North Canton, OHS/N 680-0545 N547QSRegistered aircraftBuilt 2017 · S/N 680A0094 N548QSRegistered aircraftBuilt 2017 · S/N 680A0105 N549QSRegistered aircraftBuilt 2017 · S/N 680A0098 N54CFLmtc Leasing LLC · San Antonio, TXS/N 510-0253 N54PVNostromo 2021 LLC · Jackson, WYBuilt 2010 · S/N 510-0339 N550LVPronto LLC · Oklahoma City, OKBuilt 2017 · S/N 680A0066 N550QSRegistered aircraftBuilt 2018 · S/N 680A0150 N551QSRegistered aircraftBuilt 2018 · S/N 680A0151 N552MTheory R Properties LLC · Scottsdale, AZBuilt 2009 · S/N 510-0187 N552QSRegistered aircraftS/N 680A0287 N553QSRegistered aircraftBuilt 2022 · S/N 680A0296 N554CNChoctaw Nation Of Oklahoma · Durant, OKBuilt 2021 · S/N 680A0285 N554QSRegistered aircraftBuilt 2022 · S/N 680A0297 N557SLSlc Division 4 LLC · Nashville, TNBuilt 2008 · S/N 6800199 N558QAInternational Air Services Inc Trustee · Carson City, NVBuilt 2008 · S/N 510-0134 N558RXBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 680A0033 N559QSRegistered aircraftBuilt 2017 · S/N 680A0090 N560QSRegistered aircraftBuilt 2017 · S/N 680A0110 N561QSRegistered aircraftBuilt 2017 · S/N 680A0111 N562QSRegistered aircraftBuilt 2017 · S/N 680A0112 N562SEMustang 2se LLC · Atlanta, GABuilt 2008 · S/N 510-0135 N563QSRegistered aircraftBuilt 2017 · S/N 680A0113 N564QSRegistered aircraftBuilt 2017 · S/N 680A0114 N567QSRegistered aircraftBuilt 2018 · S/N 680A0121 N569CGCardinal Ig Co · Eden Prairie, MNBuilt 2017 · S/N 680-0569 N569QSRegistered aircraftBuilt 2018 · S/N 680A0122 N56PZRtc Holdings LLC · Waxhaw, NCBuilt 2010 · S/N 510-0308 N56TEThumb Aviation LLC · Bad Axe, MIBuilt 2023 · S/N 680A0367 N570LTAlcyone Trust Corp Trustee · Wichita, KSBuilt 2013 · S/N 510-0441

Back to AD 2018-07-13