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.

N41140United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30353 N411AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4411 N411AVAircol 9 · Wilmington, DES/N 4011 N411LTKent Aviation LLC · Midland, TXBuilt 1998 · S/N 1344 N411SNAtares Funding LLC · Fisher Island, FLBuilt 1990 · S/N 48411 N411YMRida Realty Investments Corp · Houston, TXBuilt 2003 · S/N 1512 N412JDNormandy'S Triumph LLC · Tampa, FLBuilt 1992 · S/N 1188 N412SNM48412 LLC · Estero, FLBuilt 1990 · S/N 48412 N413ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 35205 N413CMCargo Aircraft Management Inc · Wilmington, OHS/N 26988 N414VGBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N 1117 N415JNAtares Funding LLC · Fisher Island, FLS/N 48415 N415LTTc Business Aviation LLC · San Francisco, CABuilt 1999 · S/N 1367 N415MA8 Windows LLC · Reno, NVBuilt 2001 · S/N 1463 N416AVAircol 19 · Wilmington, DEBuilt 2009 · S/N 4167 N418LACernicalo Leasing LLC · Wilmington, DEBuilt 2005 · S/N 34246 N419ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 41734 N419AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 26913 N41SCWorld Tech Air 23 LLC · Valencia, CABuilt 1990 · S/N 1144 N420LACaiquen Leasing LLC · Wilmington, DEBuilt 2006 · S/N 34627 N422AVUmb Bank N A Trustee · Salt Lake City, UTBuilt 2010 · S/N 4200 N422BNAntares Aviation LLC · Boca Raton, FLBuilt 1973 · S/N 20735 N423ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 35206 N423AXOmni Planes LLC · Tulsa, OKBuilt 1996 · S/N 27569 N424JSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 1444 N426AVAircol 10 · Wilmington, DEBuilt 2009 · S/N 4026 N426UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 510 N427UAUnited Airlines Inc · Chicago, ILFirst renewal noticeBuilt 1995 · S/N 512 N428ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 36353 N428KSSn 1360 LLC · Wilmington, DEBuilt 1999 · S/N 1360 N428UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 523 N429CGRica Air LLC · Castaic, CABuilt 2002 · S/N 1499 N429DDAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 1996 · S/N 1293 N429MCAtlas Air Inc · Purchase, NYBuilt 1990 · S/N 24833 N429UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 539 N4304Bank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4304 N430FEFederal Express Corp · Memphis, TNBuilt 1985 · S/N 394 N430UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 568 N431ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 43255 N431AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24632 N431FEFederal Express Corp · Memphis, TNBuilt 1984 · S/N 316 N431UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 571 N432AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27449 N432HCFast Bird LLC · Wilmington, DEBuilt 1995 · S/N 1262 N432UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 587 N433ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 41704 N433AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24400 N433UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 589 N434ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 61620 N434UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 592

Back to AD 2009-21-10 R1