Skip to content

Registered aircraft · 672

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:83-15-05-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:83-15-05-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:83-15-05-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:83-15-05-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:83-15-05-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:83-15-05-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.

N620DLAerotrust Services Corp Trustee · Wilmington, DEBuilt 1986 · S/N 22910 N625HRTryst 767 LLC · San Juan, PRBuilt 1992 · S/N 25287 N641AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30595 N641UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25091 N642UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25092 N643AZAmazon.Com Services LLC · Seattle, WABuilt 2001 · S/N 32776 N643UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25093 N644UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25094 N645GTAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 27393 N646UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25283 N647UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25284 N648UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25285 N649DLDelta Air Lines Inc · Atlanta, GABuilt 1989 · S/N 24389 N649UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25286 N650DLDelta Air Lines Inc · Atlanta, GABuilt 1986 · S/N 24390 N650GTUmb Bank N A Trustee · Salt Lake City, UTBuilt 1982 · S/N 22566 N651DLDelta Air Lines Inc · Atlanta, GABuilt 1989 · S/N 24391 N651UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25389 N652DLDelta Air Lines Inc · Atlanta, GABuilt 1989 · S/N 24392 N652GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 1983 · S/N 22571 N652UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25390 N653UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25391 N654DLDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24394 N654UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25392 N655DLDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24395 N655UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25393 N656GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23017 N656UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 25394 N657GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23018 N657UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27112 N658DLDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24420 N658UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27113 N659DLDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24421 N659GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23140 N659UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27114 N660DLDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24422 N660UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27115 N661AZAmazon.Com Services LLC · Seattle, WAS/N 29384 N661DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24972 N661UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27158 N662DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 24991 N662UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27159 N663DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 24992 N663GTAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 27568 N663UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27160 N664DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25012 N664UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 29236 N665DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25013 N665UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 29237 N666DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25034

Back to AD 83-15-05 R2