Skip to content

Registered aircraft · 166

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:2002-06-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-06-06') 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:2002-06-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-06-06')
  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:2002-06-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-06-06')
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.

N4120BBank Of Utah Trustee · Salt Lake City, UTS/N 4120 N4126BBank Of Utah Trustee · Salt Lake City, UTS/N 4126 N4202BBank Of Utah Trustee · Salt Lake City, UTS/N 4202 N4203BBank Of Utah Trustee · Salt Lake City, UTS/N 4203 N427PEAcc Integrated Services Inc · Milwaukee, WIBuilt 1984 · S/N SH3692 N428MSBank Of Utah Trustee · Salt Lake City, UTBuilt 1996 · S/N 428 N429QXPortland Community College · Portland, ORBuilt 2007 · S/N 4161 N430QXBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 4163 N436YVBank Of Utah Trustee · Salt Lake City, UTBuilt 1996 · S/N 436 N437YVWells Fargo Trust Co Na Trustee · Columbia, MDS/N 437 N4442BBank Of Utah Trustee · Salt Lake City, UTS/N 4442 N4443BBank Of Utah Trustee · Salt Lake City, UTS/N 4443 N444YVWells Fargo Trust Co Na Trustee · Salt Lake City, UTS/N 444 N4451BBank Of Utah Trustee · Salt Lake City, UTS/N 4451 N449YVBank Of Utah Trustee · Salt Lake City, UTBuilt 1996 · S/N 449 N45838United Airlines Inc · Chicago, ILS/N 397 N475SNSierra Nevada Company LLC · Sparks, NVS/N 475 N480AVBerry Aviation Inc · San Marcos, TXBuilt 1997 · S/N 484 N492AKWin Win Aviation Inc · Wake Forest, NCS/N SH3415 N492BABerry Aviation Inc · San Marcos, TXBuilt 1997 · S/N 492 N53993United States Government · Fort Belvoir, VAFirst renewal noticeBuilt 1985 · S/N 104 N539ARBank Of Utah Trustee · Salt Lake City, UTS/N 539 N541AVSierra Nevada Company LLC · Sparks, NVBuilt 2000 · S/N 541 N556PM645 Aeronautical Systems Group (Aesg) · Wpafb, OHBuilt 1996 · S/N 413 N560WKRegistration Pending · Salt Lake City, UTRegistration pendingS/N 560 N563AWUS Department Of State · Melbourne, FLS/N 563 N567WKUS Dept Of State · Melbourne, FLS/N 567 N568AWUS Department Of State · Melbourne, FLS/N 568 N569AWUS Department Of State · Melbourne, FLS/N 569 N570AWBank Of Utah Trustee · Salt Lake City, UTS/N 570 N579HCRangeflyers Inc Trustee · Wichita, KSS/N 579 N580ARBank Of Utah Trustee · Salt Lake City, UTS/N 580 N589AWBank Of Utah Trustee · Salt Lake City, UTS/N 589 N597SBInternational Air Services Inc Trustee · Carson City, NVBuilt 1997 · S/N 415 N599ARBank Of Utah Trustee · Salt Lake City, UTS/N 599 N59AGUnited States Government · Fort Belvoir, VABuilt 1981 · S/N 59 N608ARAviation Inventory Resources Inc · Alvarado, TXS/N 608 N618ANAcc Integrated Services Inc · Milwaukee, WIBuilt 1986 · S/N SH3691 N619GNBank Of Utah Trustee · Salt Lake City, UTBuilt 1995 · S/N 415 N637CCBank To Utah Trustee · Salt Lake City, UTS/N 637 N642ANAcc Integrated Services Inc · Milwaukee, WIBuilt 1983 · S/N SH3611 N646CCBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 646 N649CCBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 649 N650MXBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 11 N689ACBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2001 · S/N 4036 N705ACBank Of Utah Trustee · Salt Lake City, UTS/N 4274 N705GGUnited States Government · Fort Belvoir, VABuilt 1981 · S/N 48 N706XTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 505 N744LGAcc Integrated Services Inc · Milwaukee, WIBuilt 1988 · S/N SH3744 N792CPConocophillips Alaska Inc · Anchorage, AKBuilt 2007 · S/N 4160

Back to AD 2002-06-06