Skip to content

Registered aircraft · 709

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:97-09-02-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-09-02-R2') 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:97-09-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-09-02-R2')
  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:97-09-02-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-09-02-R2')
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 N38403United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30120 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 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 N397SWDynamic Air Solution LLC · Fort Lauderdale, FLBuilt 1995 · S/N 27691 N398DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30774 N399DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30379 N399WNCoulson Aviation (USA) Inc · Portland, ORBuilt 1995 · S/N 27693 N410WNSouthwest Airlines Co · Dallas, TXBuilt 2001 · S/N 27897 N422WNUnical Aviation Inc · Litchfield Park, AZBuilt 2002 · S/N 29826 N423UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 25325 N424WNSouthwest Airlines Co · Dallas, TXBuilt 2002 · S/N 29828 N425LVSouthwest Airlines Co · Dallas, TXBuilt 2002 · S/N 29829 N426WNSouthwest Airlines Co · Dallas, TXBuilt 2002 · S/N 29830 N427WNSouthwest Airlines Co · Dallas, TXBuilt 2002 · S/N 29831 N428WNSouthwest Airlines Co · Dallas, TXBuilt 2002 · S/N 29844 N429WNSouthwest Airlines Co · Dallas, TXBuilt 2002 · S/N 33658 N431WNSouthwest Airlines Co · Dallas, TXBuilt 2002 · S/N 29845 N435WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 32455 N436WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 32456 N437WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29832 N438USEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1990 · S/N 24560 N438WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29833 N439WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29834 N440LVSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29835 N441WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29837 N442KHAircraft 28888 LLC · Lake Mary, FLBuilt 1998 · S/N 28888 N442WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 32459 N443WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29838 N444WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29839

Back to AD 97-09-02 R2