Skip to content

Registered aircraft · 54

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:92-02-14-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:92-02-14-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:92-02-14-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:92-02-14-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:92-02-14-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:92-02-14-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.

N231XCMojave Jet LLC · Nolensville, TNS/N 231 N252NJAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 252 N319USDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 208 N321USDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 262 N325USDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 281 N328NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 298 N329NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 306 N333NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 329 N334NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 339 N335NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 340 N336NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 355 N338NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 360 N339NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 367 N340NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 372 N341NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 380 N342NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 381 N343NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 387 N344NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 388 N345NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 399 N347NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 408 N348NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 410 N349NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 417 N350NADelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 418 N351NWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 766 N352NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 778 N353NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 786 N354NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 801 N355NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 807 N356NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 818 N357NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 830 N358NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 832 N359NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 846 N360NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 0903 N361NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 0907 N362NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 0911 N363NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 0923 N364NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 0962 N365NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 0964 N366CSCsds Asset Management LLC · Rllng Hls Est, CAS/N 366 N366NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 0981 N367NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 0988 N368NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 0996 N369NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 1011 N370NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 1037 N371NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1535 N372NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1633 N373NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1641 N374NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1646 N375NCDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1789 N376NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1812

Back to AD 92-02-14 R1