Registered aircraft · 5,537

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.

N429CMSunstate Aviation LLC · Scottsdale, AZBuilt 2010 · S/N 57012 N429EXRegistered aircraftBuilt 2021 · S/N 57430 N429FWBell Textron Inc · Fort Worth, TXBuilt 2015 · S/N 57289 N429HCDelta Jet Ltd · Glastonbury, CTBuilt 2010 · S/N 57019 N429HFAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 57169 N429HRStraight Up Leasing Inc · Medford, ORBuilt 2013 · S/N 57147 N429KBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 57473 N429KVWest States Leasing Inc · Medford, ORBuilt 2019 · S/N 57381 N429LFLife Flight Network LLC · Aurora, ORBuilt 2020 · S/N 57386 N429MMMaggie'S Mixer LLC · Aspen, COBuilt 2024 · S/N 57498 N429NABell Textron Inc · Fort Worth, TXBuilt 2010 · S/N 57009 N429RLLewis Aeronautical LLC · San Antonio, TXBuilt 2014 · S/N 57190 N429RPTennessee Valley Authority · Muscle Shoals, ALBuilt 2013 · S/N 57182 N429SASuperior Ambulance Aviation Inc · Elmhurst, ILS/N 392 N429SLVentus Mf LLC · Boise, IDBuilt 2010 · S/N 57007 N429TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2020 · S/N 57395 N429TXTextron Inc · Warwick, RIS/N 57018 N429UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 539 N429VGSafety Logistics LLC · West Palm Beach, FLS/N 57025 N429WMBell Textron Inc · Fort Worth, TXBuilt 2011 · S/N 57056 N429WPSalt River Project Agri Improvement&Power District · Phoenix, AZBuilt 2017 · S/N 57318 N429XWBell Textron Inc · Fort Worth, TXBuilt 2007 · S/N 54802 N429XXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 57181 N429YCMercy Flight Inc · Buffalo, NYBuilt 2013 · S/N 57172 N42EETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 41581 N42JHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 5024 N42NPNlm Aviation LLC · Niles, MIBuilt 2019 · S/N 1905 N42NYRegistered aircraftBuilt 2014 · S/N 57214 N42PNPem Craft LLC · Danboro, PABuilt 2023 · S/N 2258 N42STTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 39 N4304Bank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4304 N430LFLife Flight Network LLC · Aurora, ORBuilt 2020 · S/N 57392 N430NGCredit Wholesale Company Inc DBA · Lubbock, TXBuilt 2013 · S/N 1430 N430TVTennessee Valley Authority · Muscel Shoals, ALBuilt 2020 · S/N 57396 N430UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 568 N431AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24632 N431CBCamellot Aviation II LLC · Emerald Isle, NCBuilt 2006 · S/N 560-5629 N431LFLife Flight Network LLC · Aurora, ORBuilt 2020 · S/N 57399 N431UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 571 N432AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27449 N432KSSsk Management 2 LLC · Bedford, OHBuilt 2001 · S/N 560-5169 N432LFLife Flight Network LLC · Aurora, ORBuilt 2020 · S/N 57406 N432MRArrow Aviation Company LLC · Broussard, LAS/N 31042 N432RBOr Aviation LLC · Richland, MSBuilt 2021 · S/N 2137 N432SSRirie Holdings LLC · St Louis, MOBuilt 2021 · S/N 2083 N432UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 587 N432WTCox Cox Filo Camel & Wilson LLC · Lake Charles, LABuilt 2010 · S/N 1196 N433AMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 1526 N433AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24400 N433LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 57484

Back to AD 2012-26-15 R1