Skip to content

AD 2004-03-15 R1

Registered aircraft · 68

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:2004-03-15-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:2004-03-15-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:2004-03-15-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:2004-03-15-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:2004-03-15-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:2004-03-15-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.

N193SJFrontera Flight Holdings Inc · Dover, DES/N 193 N330ENUniversal Hydrogen Co · Hawthorne, CABuilt 1991 · S/N 274 N349PHBam Leasing LLC · California, MDBuilt 1997 · S/N 486 N351PHBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 490 N359PHBighorn Airways Inc · Sheridan, WYBuilt 1998 · S/N 514 N360PHUmb Bank Na Trustee · Salt Lake City, UTBuilt 1998 · S/N 515 N363PHWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 1998 · S/N 520 N365PHBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 526 N367PHBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 511 N406AVBerry Aviation Inc · San Marcos, TXBuilt 1996 · S/N 460 N428MSBank Of Utah Trustee · Salt Lake City, UTBuilt 1996 · S/N 428 N436YVBank Of Utah Trustee · Salt Lake City, UTS/N 436 N437YVWells Fargo Trust Co Na Trustee · Columbia, MDS/N 437 N444YVWells Fargo Trust Co Na Trustee · Salt Lake City, UTS/N 444 N449YVBank Of Utah Trustee · Salt Lake City, UTBuilt 1996 · S/N 449 N475SNSierra Nevada Company LLC · Sparks, NVS/N 475 N480AVBerry Aviation Inc · San Marcos, TXBuilt 1997 · S/N 484 N492BABerry Aviation Inc · San Marcos, TXBuilt 1997 · S/N 492 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 N560WKBank Of Utah Trustee · Salt Lake City, UTS/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 N599ARBank Of Utah Trustee · Salt Lake City, UTS/N 599 N619GNBank Of Utah Trustee · Salt Lake City, UTBuilt 1995 · S/N 415 N637CCBank To Utah Trustee · Salt Lake City, UTS/N 637 N646CCBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 646 N649CCBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 649 N706XTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 505 N800AWUS Department Of State · Melbourne, FLS/N 573 N801MRUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 606 N802MRDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 612 N803MRDepartment Of Homeland Security · Washington, DCBuilt 2006 · S/N 626 N804MRUS Department Of Homeland Security · Washington, DCS/N 374 N805MRUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 655 N807EXFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 292 N807MRUS Department Of Homeland Security · Washington, DCBuilt 2009 · S/N 663 N808MRUS Department Of Homeland Security · Washington, DCBuilt 2009 · S/N 667 N8100LDynamic Avlease Inc · Bridgewater, VABuilt 1989 · S/N 146 N8100VDynamic Avlease Inc · Bridgewater, VABuilt 1985 · S/N 024 N810MRUS Department Of Homeland Security · Washington, DCS/N 590 N8200HDynamic Avlease Inc · Bridgewater, VABuilt 1997 · S/N 494 N8200JUS Special Operations Command · Tampa, FLBuilt 1997 · S/N 478

Back to AD 2004-03-15 R1