Registered aircraft · 5,538

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-26-15-R1') 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-26-15-R1') 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-26-15-R1')
    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-26-15-R1')
  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-26-15-R1')
  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-26-15-R1')
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.

N331NGPilatus Aircraft USA Ltd · Broomfield, COBuilt 2012 · S/N 1331 N331NVSunrise Asset Management LLC · Las Vegas, NVS/N 2625 N331QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1380 N332DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7973 N332NBDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1570 N332NVSunrise Asset Management LLC · Las Vegas, NVS/N 2638 N332PMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 5283 N332QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1428 N3333NTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 2163 N333AJB2 Skies Florida LLC · Saint Louis, MOBuilt 2021 · S/N 2116 N333BHBlh Flight LLC · Las Vegas, NVBuilt 2013 · S/N 14501167 N333DLD&S Aircraft LLC · Chicago, ILBuilt 1997 · S/N 163 N333DSAdc Holdings LLC · Manteca, CABuilt 2010 · S/N 5292 N333DXBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 8026 N333EHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5220 N333FDHc Advisors LLC · Wilmington, DEBuilt 2022 · S/N 2207 N333NBDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1582 N333NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 329 N334AMAm3 LLC · Fresno, CABuilt 2021 · S/N 2081 N334DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 8040 N334ECEntergy Services LLC · New Orleans, LABuilt 2025 · S/N 57540 N334NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1659 N334NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2831 N334NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 339 N334PMRd1989 Leasing LLC · Edina, MNBuilt 2023 · S/N 560-6349 N334QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1448 N335DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8036 N335NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1662 N335NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2852 N335NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 340 N335QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 1534 N336DXBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8063 N336EBJ C Flowers & Co LLC · New York, NYBuilt 2015 · S/N 5525 N336LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2000 · S/N 5081 N336NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1683 N336NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 355 N336QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 1506 N336RJSix Star Inc · Winter Park, FLBuilt 2004 · S/N 560-5365 N336XLCompassco LLC · Dallas, TXBuilt 2003 · S/N 560-5336 N337AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 27060 N337DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8080 N337LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2007 · S/N 5099 N337NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1685 N337NGPlatte River Aviation LLC · Potosi, WIBuilt 2012 · S/N 1337 N337NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2170 N337QTBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 791 N338DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8078 N338HRMillers Inc · Pittsburg, KSBuilt 2023 · S/N 560-6338 N338LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2000 · S/N 5150 N338NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1693

Back to AD 2012-26-15 R1