OpenAirDocs.org
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
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.

N329NVSunrise Asset Management LLC · Las Vegas, NVS/N 2876N329NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 306N329ZAKalitta Air LLC · Ypsilanti, MIBuilt 2003 · S/N 32914N32JEKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2001 · S/N 1460N330AEBank Of Utah Trustee · Salt Lake City, UTS/N 33007N330AUProject Orbis International Inc · New York, NYFirst renewal noticeBuilt 1973 · S/N 46800N330NBDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1549N330NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2786N330RWWest2east 330 LLC · Seattle, WABuilt 2000 · S/N 1382N33103Umb Bank Na Trustee · Salt Lake City, UTBuilt 1994 · S/N 27293N33132United Airlines Inc · Chicago, ILBuilt 1998 · S/N 29281N331AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 24875N331CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1986 · S/N 23747N331NBDelta Air Lines Inc · Atlanta, GAS/N 1567N331NVSunrise Asset Management LLC · Las Vegas, NVS/N 2625N33203United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30613N33209United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30581N33262United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32402N33264United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31584N33266United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32403N33284Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 31635N33286United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31600N33289United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31607N33292United Airlines Inc · Chicago, ILBuilt 2004 · S/N 33455N33294Wells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2005 · S/N 34000N332CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1987 · S/N 23707N332GAGulfstream Aerospace Corp · Savannah, GABuilt 1998 · S/N 1332N332NBDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1570N332NVSunrise Asset Management LLC · Las Vegas, NVS/N 2638N333ECFlying Falcon Inc · Frenchmans Bay Qtr, VIBuilt 2001 · S/N 1414N333FGFg Aviation LLC · Philadelphia, PABuilt 1999 · S/N 1364N333NBDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1582N333NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 329N334NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1659N334NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2831N334NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 339N335NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1662N335NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2852N335NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 340N335PHAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31265N336NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1683N336NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 355N33714United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28785N337AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 27060N337JXJetonex LLC · Sunny Isles Beach, FLS/N 33734N337NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1685N337NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2170N337PJWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 33345N338MMRegistered aircraftBuilt 1988 · S/N 1076N338NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1693
Back to AD 2009-21-10 R1