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.

N342BLChandler (U S A) Inc · Chandler, OKBuilt 2003 · S/N 5605342 N345PFFranklin Mountain Assets II LLC · El Paso, TXBuilt 2021 · S/N 560-6310 N346CCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2016 · S/N 560-6219 N346XLRolling Green Enterprises LLC · St Louis Park, MNBuilt 2003 · S/N 560-5346 N355SMAcedeuce Air LLC · Morganton, NCBuilt 2020 · S/N 560-6290 N357MJJavier'S Group LLC · Aliso Viejo, CABuilt 1999 · S/N 560-5026 N35JMVwg Open Skys LLC · Roswell, GABuilt 2006 · S/N 560-5613 N362GHQuality Leasing Inc · Niceville, FLBuilt 2004 · S/N 560-5362 N365BULegacy USA LLC · Wilmington, DEBuilt 2008 · S/N 560-5757 N369CRCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2024 · S/N 560-6369 N372XLTextron Aviation Inc · Wichita, KSBuilt 2025 · S/N 560-6372 N3750NNelson Family Holdings LLC · Wisconsin Dells, WIBuilt 2004 · S/N 560-5534 N375EFEmpirical Foods Inc · Dakota Dunes, SDBuilt 2013 · S/N 560-6132 N375RHGuarantee Management Services LLC · Glenview, ILBuilt 2010 · S/N 560-6061 N380PKKremer Co · Santa Ana, CABuilt 1999 · S/N 560-5019 N384KLTextron Aviation Inc · Wichita, KSBuilt 2024 · S/N 560-6501 N384SHSilverhawk Aviation Inc · Lincoln, NES/N 560-5309 N385SHH & H Automotive LLC · Omaha, NEBuilt 2005 · S/N 560-5590 N386SHVip Tanks LLC · La Vista, NEBuilt 2000 · S/N 560-5119 N388JEEnterprise Lease Finance LLC · Clayton, MOBuilt 2006 · S/N 560-5605 N38ADJrm Air LLC · Mooresville, NCBuilt 2019 · S/N 560-6282 N393RARoeslein & Associates Inc · Chesterfield, MOBuilt 2022 · S/N 560-6328 N394BBBrown & Brown Inc · Daytona Beach, FLBuilt 2019 · S/N 560-6264 N395WJRim 3 Group LLC · Waterford, MIBuilt 2003 · S/N 560-5330 N396DWWisch Aviation LLC · Houston, TXBuilt 2018 · S/N 560-6262 N397BCBest Air Inc · Ferdinand, INBuilt 2002 · S/N 560-5291 N398PFP F D Supply Corp · Edwardsville, ILBuilt 2026 · S/N 560-6505 N398RSJpq1 LLC · Tonka Bay, MNS/N 560-5009 N39RCRich Plane LLC · Gilberton, PABuilt 1999 · S/N 5605041 N3BZZelta LLC · Wilmington, DEBuilt 2021 · S/N 560-6313 N3JMSkybank LLC · Elkhorn, NEBuilt 2015 · S/N 560-6184 N4000KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 560-5081 N400CPCp Aviation LLC · Tulsa, OKBuilt 2007 · S/N 560-5716 N406CJSchreiber Charles J Jr Trustee · Newport Beach, CABuilt 2008 · S/N 560-5815 N40HCHoar Aviation LLC · Birmingham, ALBuilt 2018 · S/N 560-6247 N411ECAir Ports Holdings LLC · Weare, NHBuilt 2007 · S/N 560-5734 N411KQSolid Axle Management II LLC · Marshall, TXBuilt 2002 · S/N 560-5226 N412ABXls Partners Ky LLC · Louisville, KYBuilt 2007 · S/N 560-5752 N413AGPljk LLC · Leechburg, PABuilt 1998 · S/N 560-5017 N413DWDmw Aviation LLC · Marshfield, MABuilt 2010 · S/N 560-6074 N415HSWoodford Enterprises LLC · Fort Lauderdale, FLBuilt 2012 · S/N 560-6110 N416VGlacier Leasing LLC · Grand Rapids, MIBuilt 2000 · S/N 560-5109 N417JDTrmsi Inc · Plymouth Meeting, PABuilt 2009 · S/N 560-6041 N41PRDk Air LLC · Scottsdale, AZBuilt 2003 · S/N 560-5325 N420DLPerfect Agreements Leasing Inc · Trabuco Canyon, CABuilt 2002 · S/N 560-5266 N421LTSj Transportation Holdings LLC · San Angelo, TXBuilt 2004 · S/N 560-5370 N426CHCalhoun Transport LLC · Minneapolis, MNBuilt 2002 · S/N 560-5222 N427DLEmij LLC · Naples, FLBuilt 2006 · S/N 560-5622 N427MMDavjon Leasing LLC · Rogers, MNBuilt 2009 · S/N 560-6009 N427PMSunnyside Aviation LLC · Jacksonville, FLBuilt 2009 · S/N 560-6052

Back to AD 2012-06-01