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.

N262JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145533 N263JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145399 N264JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145264 N26549Corporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 145571 N266JXDelux Public Charter LLC · Dallas, TXBuilt 2003 · S/N 145726 N268JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145499 N27152United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145759 N27190United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500934 N271BCIbc Airways Inc · Fort Lauderdale, FLBuilt 2002 · S/N 145660 N27200United Airlines Inc · Chicago, ILBuilt 2006 · S/N 14500956 N27512Corporate Flight Management Inc · Smyrna, TNBuilt 2000 · S/N 145274 N284CPConocophillips Co · Houston, TXBuilt 2013 · S/N 14501178 N290MADodson Parts International Inc · Rantoul, KSS/N 145434 N291BCIbc Airways Inc · Fort Lauderdale, FLBuilt 2004 · S/N 145782 N29917Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145414 N304CEBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 145326 N305TKFat Cloud Aviation LLC · Miami, FLBuilt 2006 · S/N 14500950 N31131United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145705 N317PJCl30 LLC · Bethany, OKBuilt 2007 · S/N 14501007 N32SFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 14501060 N33182United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500909 N333BHBlh Flight LLC · Las Vegas, NVBuilt 2013 · S/N 14501167 N34110Bank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145658 N376MANewcastle Aviation Partners LLC · Fort Myers, FLS/N 145420 N3DEChampion Air LLC · Mooresville, NCBuilt 2002 · S/N 145626 N402ATAero Technologies Inc · Van Nuys, CABuilt 2003 · S/N 145702 N403RWRvr Air Charter LLC · Ft Worth, TXBuilt 2000 · S/N 145262 N404ATAero Aircraft Holdings LLC · Van Nuys, CABuilt 2003 · S/N 145715 N410MADodson Parts International Inc · Rantoul, KSS/N 145313 N41104United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145646 N438MANewcastle Aviation Partners LLC · Fort Myers, FLS/N 145232 N43VAAdvanced Air LLC · Statesville, NCBuilt 1998 · S/N 145061 N443MANewcastle Aviation Partners LLC · Fort Meyers, FLS/N 145255 N46VAAdvanced Air LLC · Statesville, NCBuilt 1999 · S/N 145103 N470DCRance King Properties Inc · Long Beach, CABuilt 2006 · S/N 14500946 N47VAAdvanced Air LLC · Statesville, NCBuilt 1999 · S/N 145110 N484WM484wm LLC · Bend, ORBuilt 2008 · S/N 14501058 N48901Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145501 N494TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 145678 N49VAAdvanced Air LLC · Statesville, NCBuilt 1999 · S/N 145.151 N500DEChampion Air LLC · Mooresville, NCBuilt 1998 · S/N 145084 N508RHHms Holdings LLC · Charlotte, NCBuilt 2003 · S/N 145769 N509GUTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 145535 N509RHHms Holdings LLC · Charlotte, NCBuilt 2001 · S/N 145517 N529GBBmh Air LLC · Fredericksburg, TXBuilt 2007 · S/N 14500994 N530CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145425 N531CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145469 N532CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145519 N534CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145531 N535CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145489

Back to AD 2004-25-21