Skip to content

Registered aircraft · 883

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

N272JGRegistered aircraftBuilt 2007 · S/N 20172 N277JHLughnasa Management LLC · Greenwich, CTBuilt 2019 · S/N 20796 N283BRanger Air LLC · Kinston, NCBuilt 2008 · S/N 20252 N286JRTf 286 LLC · Torrance, CABuilt 2004 · S/N 20014 N286MHPowerhouse Equipment Leasing LLC · Camden, DEBuilt 2013 · S/N 20400 N28FEFederal Express Leasing Corp · Memphis, TNBuilt 2012 · S/N 20361 N290CHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20029 N290CLJs Leasing LLC · Frisco, TXBuilt 2009 · S/N 20290 N2926EE350 LLC · Las Vegas, NVS/N 20658 N293HCHampton Cattle Co LLC · Orlando, FLBuilt 2011 · S/N 20330 N299TSTsi Equipment Leasing LLC · Spokane, WABuilt 2011 · S/N 20316 N29HGTractor & Equipment Co · Tukwila, WABuilt 2019 · S/N 20817 N2HLHl Aircraft LLC · Oklahoma City, OKBuilt 2016 · S/N 20631 N2XTRb171 LLC · Wilmington, DEBuilt 2023 · S/N 20938 N300DHCrystal (Wec) Air LLC · Medford, ORS/N 20083 N300JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20115 N300KCKroger Co · Cincinnati, OHBuilt 2012 · S/N 20385 N300KEOneok Inc · Tulsa, OKBuilt 2011 · S/N 20336 N300KHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20130 N300LVCapital Challenge LLC · Reno, NVBuilt 2006 · S/N 20129 N300NJFrazier Aviation LLC · Corpus Christi, TXBuilt 2004 · S/N 20013 N300NZTvpx Ars Inc Trustee · Concord, MABuilt 2013 · S/N 20397 N300RLBbl Aviation LLC · Scottsdale, AZBuilt 2006 · S/N 20090 N300TUFlying Amici Aviation LLC · Owasso, OKBuilt 2009 · S/N 20264 N300WKRenaissance Air LLC · Raleigh, NCS/N 20117 N301JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20162 N301JLRegistered aircraftBuilt 2012 · S/N 20351 N302JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 20321 N302KCorporate Jet Leasing Co LLC · Wichita, KSBuilt 2009 · S/N 20267 N302KCKroger Co · Cincinnati, OHBuilt 2013 · S/N 20389 N302LTAsig Aviation Partners LLC · Dover, DEBuilt 2007 · S/N 20157 N302PEBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 20144 N303JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 20320 N304KCKroger Co · Cincinnati, OHBuilt 2013 · S/N 20390 N304PSNuage Nine LLC · Camden, DES/N 20059 N304RJHaystack Jmr LLC · Irvine, CABuilt 2008 · S/N 20243 N305DLWilbur & Orville Inc · Wyoming, MIBuilt 2016 · S/N 20608 N305WMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 20379 N306MFUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 20009 N306WBJ & R Airways LLC · Lincoln, ALBuilt 2004 · S/N 20015 N307JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20123 N307JWFinch Lawrence G · Moraga, CABuilt 2006 · S/N 20093 N308JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 20218 N309JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 20348 N30QAWood Asg LLC · Carrollton, TXBuilt 2012 · S/N 20357 N310JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 20591 N310KEOneok Inc · Tulsa, OKBuilt 2024 · S/N 20987 N310VZRan Air LLC · Driggs, IDBuilt 2012 · S/N 20366 N311FCWheels Up Partners LLC · New York, NYBuilt 2010 · S/N 20298 N311GSCh Aircraft LLC · Palm Beach, FLBuilt 2008 · S/N 20233

Back to AD 2017-17-13