Registered aircraft · 898

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

N100EXE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2010 · S/N 50000130 N100FFMc Group Consulting LLC · Scottsdale, AZBuilt 2010 · S/N 50000141 N100FGUniversity Athletic Association Inc · Gainesville, FLBuilt 2011 · S/N 50500084 N100LCLamont Aviation LLC · Aberdeen, SDBuilt 2012 · S/N 50500124 N100MZCroatan Management LLC · Wanchese, NCBuilt 2015 · S/N 50000362 N100PUThree Pines Air LLC · Ocilla, GABuilt 2010 · S/N 50000220 N100RCRydell Co · Sioux Falls, SDBuilt 2022 · S/N 50500668 N100WXTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 50000037 N101CCKbaccc LLC · Oakland, KYBuilt 2023 · S/N 50500755 N101FGUniversity Athletic Association Inc · Gainesville, FLBuilt 2011 · S/N 50000222 N102CHWheels Up Partners LLC · New York, NYBuilt 2017 · S/N 50500428 N102EPMitc Aviation Inc · Prairie Village, KSBuilt 2009 · S/N 50000102 N103DEDore Aviation LLC · Lake Charles, LABuilt 2023 · S/N 50500735 N106KKKeller Aviation LLC · Centerville, UTBuilt 2021 · S/N 50500654 N109LEWings West II LLC · Reynoldsburg, OHBuilt 2011 · S/N 50000226 N10EMNaples Jet Center Holdings LLC · Naples, FLBuilt 2009 · S/N 50000044 N110APRrc Aviation LLC · Bullhead City, AZBuilt 2019 · S/N 50500547 N1111JFreshhope LLC · Ponte Vedra Beach, FLBuilt 2025 · S/N 50500869 N1111XValiair Lc Trustee · Casper, WYBuilt 2011 · S/N 50000245 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 N117EEAlexander Operating LLC · Woodward, OKS/N 50000417 N11CRBig Canopy LLC · Newark, DEBuilt 2009 · S/N 50000115 N11TETractor & Equipment Co · Birmingham, ALBuilt 2012 · S/N 50500081 N121JDEclipse Transport LLC · Wilmington, DEBuilt 2012 · S/N 50000267 N121PZAero One LLC · Birmingham, MIBuilt 2010 · S/N 50000153 N122CRBigly Aviation LLC · Fayetteville, ARBuilt 2013 · S/N 50000315 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 N130ECSte Aviation LLC · Brentwood, TNBuilt 2010 · S/N 50000121 N1315DBd Aviation LLC · Leawood, KSBuilt 2017 · S/N 50000383 N131BVT.F. Warren Holdings Corp · Fairhope, ALBuilt 2011 · S/N 50000268 N135BCOstrich Boot LLC · Little Rock, ARBuilt 2010 · S/N 50500017 N142TLLcl Air LLC · Calabasas, CABuilt 2010 · S/N 50000177 N145FAFexmon LLC · Dover, DEBuilt 2009 · S/N 50000091 N145MBCb Aero LLC · Midland, TXBuilt 2013 · S/N 50500154 N149GKAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2009 · S/N 50000087 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 N15VGVeritas Group Aviation LLC · Maitland, FLBuilt 2023 · S/N 50000437 N161CEDiamond Z Aviation LLC · Lafayette, LABuilt 2012 · S/N 50000274 N161PAOzark Air Operations LLC · Kansas City, MOBuilt 2010 · S/N 50000169 N168JPearson Creek Partners LLC · Springfield, MOBuilt 2014 · S/N 50500243 N168JCN168jc LLC · Wilmington, DEBuilt 2015 · S/N 50500334

Back to AD 2021-24-21