Skip to content

AD 2005-24-03 R1

Registered aircraft · 771

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:2005-24-03-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:2005-24-03-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:2005-24-03-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:2005-24-03-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:2005-24-03-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:2005-24-03-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.

N379DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30349 N380DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30266 N381DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30350 N38257United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30612 N38268United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31587 N382DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30345 N383DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30346 N384DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30347 N385DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30348 N386DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30373 N38727United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28797 N387DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30374 N388DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30375 N389DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30376 N390DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30536 N391DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30560 N39297United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34003 N392DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30561 N393DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30377 N394DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30562 N395DNDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30773 N396DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30378 N39726United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28796 N39728United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28944 N397DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30537 N398DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30774 N399DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30379 N471DSBoeing Co · Renton, WABuilt 2025 · S/N 68737 N475USUS Department Of Homeland Security · Arlington, VABuilt 2004 · S/N 33789 N477USUS Department Of Homeland Security · Arlington, VABuilt 2003 · S/N 33785 N506ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35690 N508ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35691 N512ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 39043 N513ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35192 N514ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35193 N516ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 39044 N517ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35197 N518ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 35693 N519ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 36482 N520ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 36481 N523ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 35194 N524ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35195 N525ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35692 N526ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35196 N527ASAlaska Airlines Inc · Seatac, WAS/N 35694 N528ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 35695 N529ASAlaska Airlines Inc · Seatac, WABuilt 2010 · S/N 35198 N530ASAlaska Airlines Inc · Seattle, WABuilt 2010 · S/N 36578 N531ASAlaska Airlines Inc · Seattle, WABuilt 2010 · S/N 35199 N532ASAlaska Airlines Inc · Seatac, WABuilt 2010 · S/N 36346

Back to AD 2005-24-03 R1