Skip to content

AD 2006-20-51 R1

Registered aircraft · 60

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:2006-20-51-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:2006-20-51-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:2006-20-51-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:2006-20-51-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:2006-20-51-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:2006-20-51-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.

N128TSUmb Bank Na Trustee · Salt Lake City, UTS/N 35300 N13QCJetran LLC · Horseshoe Bay, TXS/N 36306 N14QCJetran LLC · Horseshoe Bay, TXS/N 36305 N15QCJetran LLC · Horseshoe Bay, TXS/N 36307 N2135UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62646 N2136UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62648 N2138UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62649 N2140UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62651 N2142UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 63722 N220XTBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 29739 N2243UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 63723 N2250UUnited Airlines Inc · Chicago, ILBuilt 2019 · S/N 66590 N2251UUnited Airlines Inc · Chicago, ILBuilt 2020 · S/N 66591 N2331UUnited Airlines Inc · Chicago, ILBuilt 2016 · S/N 62642 N2332UUnited Airlines Inc · Chicago, ILBuilt 2016 · S/N 62643 N2333UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62644 N2341UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 63721 N2352UUnited Airlines Inc · Chicago, ILBuilt 2020 · S/N 66592 N2534UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62645 N261GEBank Of Utah Trustee · Salt Lake City, UTS/N 32790 N2639UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62650 N2644UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 63724 N2645UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64989 N2737UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62647 N2747UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64991 N2748UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64994 N2749UUnited Airlines Inc · Chicago, ILBuilt 2019 · S/N 66589 N2846UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64990 N377CLPetrus Iagcas 777 LLC · Dallas, TXS/N 35164 N399MTBank Of Utah Trustee · Salt Lake City, UTS/N 29741 N463ACUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 35299 N60VLBank Of Utah Trustee · Salt Lake City, UTS/N 39254 N666CATvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 36157 N705DNJetran LLC · Horseshoe Bay, TXBuilt 2009 · S/N 29742 N709DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 40559 N70VLBank Of Utah Trustee · Salt Lake City, UTS/N 30440 N710DNJetran LLC · Horseshoe Bay, TXBuilt 2010 · S/N 40560 N717ANAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 31543 N718ANAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 41665 N719ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 41668 N720ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33522 N721ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31546 N722ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 31547 N723ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 33125 N724ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 31548 N725ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 41666 N726ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 31550 N727ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 33541 N728ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 31553 N729ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 33127

Back to AD 2006-20-51 R1