Skip to content

Registered aircraft · 431

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-25-21') 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-25-21') 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-25-21')
    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-25-21')
  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-25-21')
  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-25-21')
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.

N688AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500849 N689ECAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500853 N690AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500858 N691AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500860 N692AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500866 N693AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500868 N694AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500869 N695AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500870 N696AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500874 N697ABAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500875 N697EEEmbraer Executive Aircraft Inc · Melbourne, FLS/N 145-1197 N698CBAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500877 N699AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500883 N6GDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 14500983 N700LZValiair Lc Trustee · Casper, WYS/N 14500952 N704PGBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 145174 N70VAAdvanced Air LLC · Statesville, NCBuilt 2001 · S/N 145397 N712AEAero Aircraft Holdings LLC · Van Nuys, CAS/N 145247 N725BDBdg Aircharter Inc · Syosset, NYBuilt 2008 · S/N 14501034 N728PH728 Services LLC · New York, NYBuilt 2007 · S/N 14500985 N742SPOur Plane LLC · Kingwood, TXBuilt 2011 · S/N 14501122 N752SPPrincipal Aviation Partners LLC · Camden, DEBuilt 2005 · S/N 14500903 N7965MChasing The Sun LLC · Bronx, NYBuilt 2012 · S/N 14501164 N804CECummins Inc · Columbus, INBuilt 2012 · S/N 14501153 N806AECorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145503 N809AECorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145521 N809TDAero Aircraft Holdings II LLC · Van Nuys, CABuilt 2004 · S/N 14500809 N810AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 145525 N815AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145545 N818HRHr Inv LLC · Omaha, NEBuilt 2009 · S/N 14501105 N819AEAvi Sales & Leasing Services LLC · Muskegon, MIS/N 145566 N81EXExodus Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 145053 N821AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145577 N822AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145581 N825AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145589 N825HKBank Of Utah Trustee · Salt Lake City, UTS/N 145510 N826AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145592 N830AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145615 N831AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145616 N832HKCbg LLC · Wilsonville, ORBuilt 2003 · S/N 145771 N833AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145629 N835HKCbg LLC · Wilsonville, ORBuilt 2003 · S/N 145670 N836AECorporate Flight Management Inc DBA · Smyrna, TNBuilt 2002 · S/N 145635 N837AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145647 N838AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145651 N840AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145656 N842AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145673 N842HKAerovision Aircraft Services LLC · Muskegon, MIBuilt 2004 · S/N 14500830 N846AECorporate Flight Management Inc DBA · Smyrna, TNBuilt 2003 · S/N 145692 N848AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 145710

Back to AD 2004-25-21