Skip to content

AD 2000-20-03 R1

Registered aircraft · 417

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-20-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-20-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-20-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-20-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-20-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-20-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.

N835AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8035 N836AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 8036 N8390ADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 7390 N8409NDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 7409 N840AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2005 · S/N 8040 N8416BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 7416 N841FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 2006 · S/N 8064 N8432ALogos Aviation Inc · Fort Lauderdale, FLBuilt 2000 · S/N 7432 N8444FLogos Aviation Inc · Fort Lauderdale, FLBuilt 2000 · S/N 7444 N8458ALogos Aviation Inc · Fort Lauderdale, FLBuilt 2000 · S/N 7458 N845ASDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N 7324 N845SASlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7965 N8492CDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 7492 N8495BDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 7495 N8501FDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 7501 N8505QAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7505 N8506CAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7506 N850NBValiair Lc Trustee · Casper, WYBuilt 1997 · S/N 7211 N850RDLgs Holding Group 2013 LLC · Stockbridge, GABuilt 2009 · S/N 8103 N850RJUS Department Of Energy · Richland, WABuilt 1996 · S/N 7152 N8515FAm Pm Services LLC - Series One · Northbrook, ILBuilt 2001 · S/N 7515 N8516CAm Pm Services LLC- Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7516 N851AVWells Fargo Trust Co Na Trustee · Columbia, MDS/N 7851 N8525BAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7525 N8532GAm Pm Services LLC- Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7532 N8533DAm Pm Services Llcblue Sky Series · Northbrook, ILBuilt 2001 · S/N 7533 N8541DAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7541 N854ASSkywest Airlines Inc · St. George, UTBuilt 2000 · S/N 7382 N8554AAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7554 N8560FAm Pm Services LLC - Blue Skies Series · Northbrook, ILBuilt 2001 · S/N 7560 N856ASSkywest Airlines Inc · St George, UTBuilt 2000 · S/N 7404 N8577DAm Pm Services LLC · Northbrook, ILBuilt 2001 · S/N 7577 N8580AAm Pm Services LLC - Alpha Series · Northbrook, ILBuilt 2001 · S/N 7580 N8587EAm Pm Services LLC - Alpha Series · Northbrook, ILBuilt 2001 · S/N 7587 N8588DAm Pm Services LLC - Alpha Serie · Northbrook, ILBuilt 2001 · S/N 7588 N8598BAm Pm Services LLC · Northbrook, ILBuilt 2001 · S/N 7598 N8604CAm Pm Services LLC Foxtrot Series · Northbrook, ILBuilt 2002 · S/N 7604 N860JJ860jj LLC · Brookfield Townshi, OHBuilt 2001 · S/N 7471 N8611AAm Pm Services LLC Foxtrot Series · Northbrook, ILBuilt 2002 · S/N 7611 N8623AAm Pm Services LLC - Foxtrot Series · Northbrook, ILBuilt 2002 · S/N 7623 N8631EAm Pm Services LLC - Foxtrot Series · Northbrook, ILBuilt 2002 · S/N 7631 N8646AAm Pm Services LLC - Foxtrot Series · Northbrook, ILBuilt 2002 · S/N 7646 N8659BAm Pm Services LLC - Departure Series · Northbrook, ILBuilt 2002 · S/N 7659 N8665AAm Pm Services LLC - Departure Series · Northbrook, ILBuilt 2002 · S/N 7665 N8672AAm Pm Services LLC Departure Series · Northbrook, ILBuilt 2002 · S/N 7672 N8674ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 7674 N8683BSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2002 · S/N 7683 N8688CGold Coast Aviation · Fort Lauderdale, FLBuilt 2002 · S/N 7688 N8694ASlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2002 · S/N 7694 N8696CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 7696

Back to AD 2000-20-03 R1