Registered aircraft · 677

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

N100FGUniversity Athletic Association Inc · Gainesville, FLBuilt 2011 · S/N 50500084 N100LCLamont Aviation LLC · Aberdeen, SDBuilt 2012 · S/N 50500124 N100RCRydell Co · Sioux Falls, SDBuilt 2022 · S/N 50500668 N101CCKbaccc LLC · Oakland, KYBuilt 2023 · S/N 50500755 N102CHWheels Up Partners LLC · New York, NYBuilt 2017 · S/N 50500428 N103DEDore Aviation LLC · Lake Charles, LABuilt 2023 · S/N 50500735 N106KKKeller Aviation LLC · Centerville, UTBuilt 2021 · S/N 50500654 N110APRrc Aviation LLC · Bullhead City, AZBuilt 2019 · S/N 50500547 N1111JFreshhope LLC · Ponte Vedra Beach, FLBuilt 2025 · S/N 50500869 N111HRInverness LLC · West Des Moines, IABuilt 2022 · S/N 50500657 N1124XFast Rabbit Aviation LLC · Mercer Island, WABuilt 2025 · S/N 50500919 N114KCBeta Fleet LLC · South Burlington, VTBuilt 2011 · S/N 50500067 N11TETractor & Equipment Co · Birmingham, ALBuilt 2012 · S/N 50500081 N123SSky One Air LLC · Miami, FLBuilt 2019 · S/N 50500519 N124EKFraned Corp · Wilmington, DEBuilt 2020 · S/N 50500600 N124FGBrew Culture LLC · Jackson, WYBuilt 2015 · S/N 50500319 N129GDDij Air LLC · Coral Gables, FLS/N 50500053 N12MLVantage Air Holdings LLC · West Harrison, NYBuilt 2014 · S/N 50500247 N12ZWRodforce 2 LLC · Omaha, NEBuilt 2014 · S/N 50500248 N135BCOstrich Boot LLC · Little Rock, ARBuilt 2010 · S/N 50500017 N145MBCb Aero LLC · Midland, TXBuilt 2013 · S/N 50500154 N14AQMaxair LLC · Appleton, WIBuilt 2012 · S/N 50500065 N156PGOsprey Aviation LLC · Cedar Falls, IABuilt 2018 · S/N 50500488 N157BDRdljr LLC · Beaverton, ORBuilt 2016 · S/N 50500367 N168JPearson Creek Partners LLC · Springfield, MOBuilt 2014 · S/N 50500243 N168JCN168jc LLC · Wilmington, DEBuilt 2015 · S/N 50500334 N16MLBretoneus Ventures Inc · Tinmouth, VTBuilt 2011 · S/N 50500045 N173PJR A N Air LLC · Atlanta, GABuilt 2013 · S/N 50500167 N175MCAirex 3 LLC · Livonia, MIBuilt 2019 · S/N 50500526 N17DBD&B Farmstand LLC · Hoboken, NJBuilt 2020 · S/N 50500566 N1873Koch Transportation LLC · Evansville, INBuilt 2021 · S/N 50500652 N1887BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 50500210 N18MFAvion Zito II LLC · La Jolla, CABuilt 2025 · S/N 50500849 N1920Perdue Farms Inc · Salisbury, MDBuilt 2021 · S/N 50500603 N1932MQt Asset 1 LLC · La Jolia, CABuilt 2024 · S/N 50500810 N1952RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 50500618 N1959N300 Aviation LLC · Lexington, KYBuilt 2018 · S/N 50500466 N199BAPhenom Acquisition LLC · New York, NYBuilt 2015 · S/N 50500290 N1CHCmh Services Aviation Inc · Maryville, TNBuilt 2025 · S/N 50500888 N1KACmh Services Aviation Inc · Maryville, TNBuilt 2024 · S/N 50500818 N1MRN3818c Training LLC · Carrollton, TXBuilt 2019 · S/N 50500552 N1WCWc Air Transport LLC · Sevierville, TNS/N 50500555 N1WGWcm-1 LLC · Broomfield, COBuilt 2023 · S/N 50500733 N20FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 50500800 N20TQ8405 La LLC · Dallas, TXBuilt 2011 · S/N 50500044 N2152HHorton Transportation Inc · Roseville, MNBuilt 2015 · S/N 50500274 N216TXTransmedics Inc · Belgrade, MTBuilt 2024 · S/N 50500807 N222KBRegistered aircraftBuilt 2021 · S/N 50500605 N225QTQuality Air Leasing LLC · St George, UTBuilt 2025 · S/N 50500878 N227SJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 50500723

Back to AD 2014-19-01