Registered aircraft · 726

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:2012-06-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:2012-06-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:2012-06-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:2012-06-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:2012-06-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:2012-06-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.

N23LXSoft Cloud Consulting LLC · North Salt Lake, UTBuilt 2008 · S/N 560-6010 N23QSRegistered aircraftS/N 560-6519 N245DJLtlvsd LLC · Wilmington, DES/N 560-5662 N245XLSideline Inc · Tuscaloosa, ALBuilt 2018 · S/N 560-6245 N247MPRoar Aviation LLC · Bloomington, ILBuilt 2003 · S/N 5605348 N247RUAlliance Air II LLC · Burlington, NCBuilt 2017 · S/N 560-6241 N24KSYampa LLC · Kenner, LABuilt 2007 · S/N 560-5750 N24PHExcel3 LLC · Carmel, INBuilt 2005 · S/N 560-5571 N24QSTextron Aviation Inc · Wichita, KSS/N 560-6526 N253TBlue Link LLC · Bay City, WIBuilt 2000 · S/N 560-5114 N255RC255rc LLC · Atlanta, GAS/N 560-5554 N255SMN255sm LLC · Henderson, NVBuilt 2015 · S/N 560-6194 N25PPTsc Aircraft LLC · Saint Louis, MOBuilt 2006 · S/N 560-5671 N25QSTextron Aviation Inc · Wichita, KSS/N 560-6527 N264VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5264 N269CRContinental Resources Inc · Baker, MTBuilt 2026 · S/N 560-6509 N26TBirmingham Bravo LLC · Birmingham, ALBuilt 2013 · S/N 560-6133 N26XLVal 67vc LLC · Green Cove Springs, FLBuilt 2011 · S/N 560-6086 N275BTDs-Mf Management LLC · Norman, OKBuilt 2024 · S/N 560-6365 N278XL560xl LLC · Newark, DEBuilt 2002 · S/N 560-5278 N281ETextron Aviation Inc · Wichita, KSS/N 560-6521 N286VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5286 N291DVFall River Aviation LLC · Corvallis, ORBuilt 2001 · S/N 560-5146 N296VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5296 N29QAWar Horse Aviation LLC · Whitsett, TXBuilt 2002 · S/N 560-5277 N2KK2872 Holdings LLC · Burleson, TXBuilt 2003 · S/N 560-5319 N300DACrete Carrier Corp · Lincoln, NES/N 560-5270 N301HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2009 · S/N 560-6019 N301LWings Of Justice LLC · Bozeman, MTBuilt 2012 · S/N 560-6101 N301LGPilatus Drh LLC · Wilmington, DEBuilt 2022 · S/N 560-6322 N301VRTonglen LLC · Farmingdale, NYBuilt 2002 · S/N 560-5301 N304MRMirric Entertainment LLC · Pittsburgh, PABuilt 1999 · S/N 560-5033 N30EKHw Consulting LLC · Reno, NVBuilt 2004 · S/N 560-5369 N314CWR & B Aviation LLC · Columbia, MOBuilt 2025 · S/N 560-6504 N318MMPerfect Agreement Leasing Inc · Trabuco Canyon, CABuilt 2001 · S/N 560-5220 N318XLCarriage Dpb LLC · Gainesville, GABuilt 2022 · S/N 560-6318 N321CLVolatus Aviation Holdings LLC · Houston, TXBuilt 2004 · S/N 560-5527 N322JCCavender Aviation LLC · Oklahoma City, OKBuilt 2019 · S/N 560-6272 N325NDN325nd LLC · Wilmington, DEBuilt 2002 · S/N 560-5284 N327JAHiland Dairy Foods Company LLC · Springfield, MOBuilt 2024 · S/N 560-6360 N327MMMoose Aviation LLC · Wilmington, DEBuilt 2001 · S/N 560-5149 N328RPN328rp Aviation LLC · Dayton, OHBuilt 2007 · S/N 560-5747 N32KMAirmail LLC · North Salt Lake, UTBuilt 2007 · S/N 560-5715 N330GCOia Air Corp · Nashua, NHBuilt 2005 · S/N 560-5501 N330KPWp Air LLC · Morristown, TNBuilt 2022 · S/N 560-6330 N334PMRd1989 Leasing LLC · Edina, MNBuilt 2023 · S/N 560-6349 N336RJSix Star Inc · Winter Park, FLBuilt 2004 · S/N 560-5365 N336XLCompassco LLC · Dallas, TXBuilt 2003 · S/N 560-5336 N338HRMillers Inc · Pittsburg, KSBuilt 2023 · S/N 560-6338 N33EHTextron Aviation Inc · Wichita, KSS/N 560-6520

Back to AD 2012-06-01