Skip to content

Registered aircraft · 179

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:2010-17-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:2010-17-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:2010-17-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:2010-17-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:2010-17-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:2010-17-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.

N100EXE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2010 · S/N 50000130 N100FFMc Group Consulting LLC · Scottsdale, AZBuilt 2010 · S/N 50000141 N100MZCroatan Management LLC · Wanchese, NCBuilt 2015 · S/N 50000362 N100PUThree Pines Air LLC · Ocilla, GABuilt 2010 · S/N 50000220 N100WXTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 50000037 N101FGUniversity Athletic Association Inc · Gainesville, FLBuilt 2011 · S/N 50000222 N102EPMitc Aviation Inc · Prairie Village, KSBuilt 2009 · S/N 50000102 N109LEWings West II LLC · Reynoldsburg, OHBuilt 2011 · S/N 50000226 N10EMNaples Jet Center Holdings LLC · Naples, FLBuilt 2009 · S/N 50000044 N1111XValiair Lc Trustee · Casper, WYBuilt 2011 · S/N 50000245 N11CRBig Canopy LLC · Newark, DEBuilt 2009 · S/N 50000115 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 N130ECSte Aviation LLC · Brentwood, TNBuilt 2010 · S/N 50000121 N131BVT.F. Warren Holdings Corp · Fairhope, ALBuilt 2011 · S/N 50000268 N142TLLcl Air LLC · Calabasas, CABuilt 2010 · S/N 50000177 N145FAFexmon LLC · Dover, DEBuilt 2009 · S/N 50000091 N149GKAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2009 · S/N 50000087 N161CEDiamond Z Aviation LLC · Lafayette, LABuilt 2012 · S/N 50000274 N161PAOzark Air Operations LLC · Kansas City, MOBuilt 2010 · S/N 50000169 N16SJJk Leasing LLC · Gilbert, AZBuilt 2016 · S/N 50000369 N173GHClark Aviation LLC · Ashland, KYBuilt 2010 · S/N 50000173 N175EM882 Aviation Inc · West Harrison, NYNon-citizen corporation, flight hours not reportedBuilt 2009 · S/N 50000106 N175EWN1235l LLC · Tallahassee, FLBuilt 2010 · S/N 50000188 N178CMTnka178 LLC · Boca Raton, FLBuilt 2010 · S/N 50000178 N188TMAeromerica LLC · Las Vegas, NVBuilt 2009 · S/N 50000124 N18YPSpark Aviation LLC · West Harrison, NYBuilt 2008 · S/N 50000009 N190BWJjp Aviation LLC · Mobile, ALBuilt 2009 · S/N 50000028 N19SGBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 50000241 N1WBWeber Aviation Group LLC · Kenosha, WIBuilt 2010 · S/N 50000137 N200Nuwest Builders Inc · Whitefish, MTBuilt 2009 · S/N 50000058 N203SSAircraft Holding And Leasing LLC · Sarasota, FLBuilt 2013 · S/N 50000293 N208DXAsa Parts LLC · Dallas, TXBuilt 2009 · S/N 50000097 N20XXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 50000281 N214PCFly Jpi LLC · Pittsburgh, PABuilt 2012 · S/N 50000298 N218RGPtaryndactyl LLC · Indianapolis, INBuilt 2010 · S/N 50000172 N21SBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 50000154 N221EMTtt Flyers LLC · South Bend, INBuilt 2009 · S/N 50000025 N222KZWarrior Notes · Destrehan, LABuilt 2013 · S/N 50000302 N225ASRichelieu LLC · San Francisco, CABuilt 2011 · S/N 50000239 N226KVC2 Squared Consulting LLC · Port Orange, FLBuilt 2009 · S/N 50000071 N228GSCapital Holdings 243 LLC · Brownsville, TXBuilt 2010 · S/N 50000112 N22DKEquity Partner LLC · Wilmington, DEBuilt 2014 · S/N 50000338 N241DENorthgate Aviation LLC · Colorado Springs, COBuilt 2009 · S/N 50000070 N247RWBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 50000019 N24PFPsf Aviation LLC · Ponte Vedra Beach, FLBuilt 2011 · S/N 50000259 N264AGSugarland Phenom LLC · Charlotte, NCBuilt 2010 · S/N 50000192 N270EAMk Aviation LLC · Westlake, LAS/N 50000270 N277BGKap Holdings Sulphur LLC · Sulphur, LABuilt 2014 · S/N 50000344

Back to AD 2010-17-01