Skip to content

AD 2000-03-03 R1

Registered aircraft · 781

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:2000-03-03-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:2000-03-03-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:2000-03-03-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:2000-03-03-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:2000-03-03-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:2000-03-03-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.

N477CASkywest Airlines Inc · Saint George, UTBuilt 2002 · S/N 7670 N479CASkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7675 N487CASkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7729 N494CASkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7765 N495DDKm Aviation LLC · Houston, TXBuilt 2001 · S/N 5495 N496CASkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 7791 N498CASkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7792 N498SARi Millennium II LLC · Beverly, MABuilt 2001 · S/N 7564 N499PHCanyon Capital V LLC · Helena, MTS/N 5014 N4JSDoculeasing LLC · Austin, TXBuilt 1991 · S/N 5092 N500AEAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 10025 N500LRNam Jet LLC · Great Neck, NYBuilt 1987 · S/N 5012 N500PRPenske Racing Inc · New Castle, DEBuilt 2003 · S/N 7846 N500PVVi Holdings LLC · Henderson, NVBuilt 1999 · S/N 5400 N501BGAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 10017 N501KVRoman Empire Aba Services Inc · Goodyear, AZBuilt 1995 · S/N 5173 N502AEAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 10018 N502GJBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 10011 N503GJBank Of Utah Trustee · Salt Lake City, UTS/N 10019 N505AEAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 10053 N506AEAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 10056 N506CASkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7793 N507AEAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 10059 N508AEAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 10072 N509AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10078 N509GJSkywest Leasing Inc · St George, UTBuilt 2004 · S/N 10153 N510AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10105 N510SJN510sj LLC · Las Vegas, NVBuilt 2001 · S/N 7481 N511AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10107 N511DDDesert Aviation Partners LLC · Anchorage, AKBuilt 1995 · S/N 5187 N513AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10114 N514AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10119 N515AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10121 N515LFAdelante Aviation LLC · Leawood, KSBuilt 1986 · S/N 3052 N516AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10123 N517AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10124 N517BBShiloh International Inc · Brooklyn, NYS/N 5047 N518AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10126 N518JGJoe Gibbs Racing LLC · Huntersville, NCBuilt 2002 · S/N 5545 N519AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10131 N519GJBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 10026 N520DCAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10140 N520GJBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 10065 N521AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10142 N522AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10147 N523AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10152 N523GJSkywest Leasing Inc · St George, UTBuilt 2003 · S/N 10125 N523JGRama Z2 LLC · Bellevue, WABuilt 2001 · S/N 5508 N524AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10154 N526GJSkywest Leasing Inc · Saint George, UTBuilt 2004 · S/N 10129

Back to AD 2000-03-03 R1