Skip to content

AD 2009-21-10 R1

Registered aircraft · 4,274

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:2009-21-10-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:2009-21-10-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:2009-21-10-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:2009-21-10-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:2009-21-10-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:2009-21-10-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.

N743AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6739 N743CKKalitta Air LLC · Ypsilanti, MIBuilt 1993 · S/N 26350 N744AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22221 N744CKKalitta Air LLC · Ypsilanti, MIBuilt 1993 · S/N 26353 N744PBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1287 N745AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6746 N745AXCargo Aircraft Management Inc · Wilmington, OHS/N 22222 N745CKKalitta Air LLC · Ypsilanti, MIBuilt 1998 · S/N 26361 N745VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1289 N746AAMidnight Engineering LLC · Fort Lauderdale, FLS/N 26639 N746JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3622 N746MNSparta Aviation Group LLC · Loveland, OHBuilt 1990 · S/N 1136 N746UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1297 N7470Museum Of Flight Foundation · Seattle, WABuilt 1969 · S/N 20235 N747GFGe Engine Leasing Holdings Inc · Cincinnati, OHBuilt 1994 · S/N 26355 N747SFAerospace Trust Management LLC Trustee · Wilmington, DES/N 21575 N747UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1301 N74856United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32815 N748AVNavigator Aviation II Msn 6862 Trust · Wilmington, DEBuilt 2015 · S/N 6862 N748UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1311 N749AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 22226 N749BCAlta 777 LLC · Salt Lake City, UTS/N 33372 N749USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1313 N74GGDwm Logistics LLC · San Luis Obispo, CABuilt 1998 · S/N 1331 N750ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30259 N750AVNavigator Aviation II Msn 7120 Trust · Wilmington, DEBuilt 2016 · S/N 7120 N750AXBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 22227 N750UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1315 N751ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30798 N751UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1317 N7520AAerothrust Holdings Leasing LLC · Miami, FLS/N 49897 N752ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30260 N752AXAeroacq Partners LLC · Laud By Sea, FLS/N 23434 N752CXCargo Aircraft Management Inc · Wilmington, OHS/N 24451 N752DHKalitta Charters II LLC · Ypsilanti, MIBuilt 1981 · S/N 22466 N752LTL-3 Communications Advanced Aviation LLC · Kalispell, MTS/N 26058 N752USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1319 N753ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30261 N753USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1326 N75410United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30127 N7541AFrontera Flight Holdings Inc · Dover, DEBuilt 1990 · S/N 49995 N75425United Airlines Inc · Chicago, ILBuilt 2008 · S/N 33460 N75426United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31622 N75428United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31633 N75429United Airlines Inc · Chicago, ILBuilt 2008 · S/N 30130 N75432United Airlines Inc · Chicago, ILBuilt 2009 · S/N 32835 N75433United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33527 N75435United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33529 N75436United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33531 N7548AFrontera Flight Holdings Inc · Dover, DES/N 53030

Back to AD 2009-21-10 R1