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.

N5150VMacon Aero Connections LLC · Macon, GABuilt 2008 · S/N 560-5776 N515CPFac Logistics LLC · Rocky Mount, NCBuilt 2006 · S/N 560-5626 N517MEBbk Partners LLC · York, PABuilt 2008 · S/N 560-6005 N519EP Ksep LLC · Dublin, TXBuilt 2008 · S/N 560-5768 N51CAOklahoma Jet 560-5234 LLC · Ponca City, OKBuilt 2002 · S/N 560-5234 N51CUUnited Bottling Management Company LLC · Birmingham, ALBuilt 2022 · S/N 560-6321 N51VTVirginia Tech Foundation Inc · Blacksburg, VABuilt 2000 · S/N 560-5072 N521BBBell Bank · Fargo, NDBuilt 2022 · S/N 560-6329 N524BBBell Bank · Oklahoma City, OKBuilt 2018 · S/N 560-6259 N524DMMax Aircraft LLC · Moon Township, PABuilt 2011 · S/N 560-6090 N524DPDodson International Parts Inc · Rantoul, KSBuilt 2004 · S/N 560-5526 N525BBBell Bank · Oklahoma City, OKBuilt 2020 · S/N 560-6285 N527EECrown Aviation LLC · Holland, MIBuilt 2005 · S/N 560-5549 N528ACLegend Air LLC · Waukesha, WIS/N 560-5695 N529LLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 560-5557 N529NMTnm Enterprises LLC · Newark, DEBuilt 2017 · S/N 560-6182 N52MWManagement West LLC · Aurora, ORBuilt 2011 · S/N 560-6085 N532MTBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 560-6118 N533CCMt Aviation LLC · Cincinnati, OHBuilt 2010 · S/N 560-6063 N534CCMagg One Holdings LLC · Fulton, MDBuilt 2010 · S/N 560-6070 N535MAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 560-6256 N536JA560-5166 LLC · Greenfield, INBuilt 2001 · S/N 560-5166 N538WAHaven Jet LLC · Dyersburg, TNBuilt 2013 · S/N 560-6135 N539WATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 560-6346 N53UBColumbia Bank · Lake Oswego, ORBuilt 2013 · S/N 560-6159 N53WFAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1999 · S/N 560-5057 N540PJAnywhere But Here LLC · Zelienople, PABuilt 2025 · S/N 560-6378 N5434KKowalik Raymond J Trustee · Lees Summit, MOBuilt 2003 · S/N 560-5345 N543TATriton Jets LLC · Lexington, KYS/N 560-5331 N543WGAlliance Aviation Group LLC · Wilmington, DES/N 560-5243 N547JRTimberland Aviation LLC · Iowa City, IABuilt 2007 · S/N 560-5682 N54CGAll C'S LLC · Greenville, NCBuilt 2021 · S/N 560-6301 N54TATeam Aero LLC · Shawnee, KSS/N 560-5128 N552SCPtc Aviation LLC · Northport, ALBuilt 2001 · S/N 560-5144 N555WZHi Tequity Air Holdings Spv LLC · Melbourne Beach, FLBuilt 2004 · S/N 560-5366 N556LSCharlie Brown Air III LLC · Boca Raton, FLBuilt 2002 · S/N 560-5276 N556WFClearair LLC · Taylorsville, NCBuilt 1999 · S/N 560-5024 N559HFAlmond Co · Madera, CABuilt 2016 · S/N 560-6213 N55VWVariety Wholesalers Inc · Henderson, NCBuilt 2000 · S/N 560-5076 N560ADAir Direct LLC · Powderly, TXBuilt 2002 · S/N 560-5239 N560APSouthern Capital Air LLC · Atlanta, GABuilt 2007 · S/N 560-5707 N560ARBrook Haven Properties LLC · Camden, DEFirst renewal noticeS/N 560-6026 N560AWAurora Ventures LLC · Saint Paul, MNBuilt 2003 · S/N 560-5351 N560BDDm Petroleum LLC · Sherman, TXBuilt 2002 · S/N 560-5257 N560BERegistered aircraftBuilt 2025 · S/N 560-6503 N560BGNight Eagle Aviation LLC · Zelienople, PABuilt 2007 · S/N 560-5703 N560BTG & R Aviation LLC · Louisville, KYBuilt 1999 · S/N 560-5031 N560CGMgl Partners LLC · Saint Louis, MOBuilt 2000 · S/N 560-5121 N560CRVmair Partners Inc · Wilmington, DEBuilt 2002 · S/N 560-5229 N560DRAj Aero Holdings Inc · Dover, DEBuilt 2000 · S/N 560-5073

Back to AD 2012-06-01