Skip to content

Registered aircraft · 1,287

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:2002-22-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-22-13') 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:2002-22-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-22-13')
  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:2002-22-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-22-13')
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.

N880ASSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7606 N880CCIntegrated Management Services LLC · Nashville, TNFirst renewal noticeBuilt 2013 · S/N 5949 N880FCFawkescorp LLC · Lewes, DES/N 5337 N880MGDream Jet LLC · Leawood, KSBuilt 1994 · S/N RK83 N880SASlate Aircraft Company LLC · Johnstown, PAS/N 7978 N881ASSkywest Airlines Inc · Saint George, UTBuilt 2001 · S/N 7496 N881BGEtosha LLC · Weston, FLBuilt 1991 · S/N 5097 N8828DBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 7828 N882SFSuperior Aviation Inc Trustee · Orlando, FLS/N 7460 N8836AGold Coast Aviation · Fort Lauderdale, FLBuilt 2003 · S/N 7836 N883CAAdlakha Aviation LLC · Pflugerville, TXBuilt 1999 · S/N 5406 N8847ASlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2003 · S/N 7847 N8855ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 7855 N8869BViajet LLC · Johnstown, PABuilt 2003 · S/N 7869 N886ASSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7531 N8877ASlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2003 · S/N 7877 N887DDRegistered aircraftN-number assigned (import), not yet registeredS/N 6242 N8886AGold Coast Aviation · Fort Lauderdale, FLBuilt 2003 · S/N 7886 N888DHCanadair 5305 LLC · Dover, DEBuilt 1996 · S/N 5305 N888GBRegistered aircraftBuilt 2008 · S/N 5771 N888QLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 5566 N888YCJamm Leasing II LLC · Park City, UTBuilt 1999 · S/N 5402 N8891AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7891 N8894AGold Coast Aviation · Fort Lauderdale, FLS/N 7894 N8896AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7896 N889ASFrontera Flight Holdings Inc · Dover, DEBuilt 2001 · S/N 7538 N889MCPnc Bank Na · Boise, IDBuilt 2025 · S/N 6217 N88YHSuperior Aviation Inc · Orlando, FLS/N 7738 N88YRSuperior Aviation Inc · Orlando, FLS/N 7607 N89Federal Aviation Administration · Oklahoma City, OKBuilt 2009 · S/N 5815 N8908DSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7908 N890SARi Millennium I LLC · Beverly, MABuilt 2001 · S/N 7548 N8921BAm Pm Services LLC · Northbrook, ILBuilt 2004 · S/N 7921 N8930EBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 7930 N8933BGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7933 N8936AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7936 N8940EAm Pm Services LLC - Adventure Series · Northbrook, ILBuilt 2004 · S/N 7940 N8942AViajet LLC · Johnstown, PABuilt 2004 · S/N 7942 N8943AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7943 N8944BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 7944 N8946ABank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 7946 N8948BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 7948 N895CCK & S Aircraft LLC · Scottsdale, AZBuilt 2007 · S/N 5727 N895CPPag Inc · Little Rock, ARBuilt 1992 · S/N RK-59 N8960AAm Pm Services LLC - Adventure Series · Northbrook, ILBuilt 2004 · S/N 7960 N8964EAm Pm Services LLC - Adventure Series · Northbrook, ILBuilt 2004 · S/N 7964 N8969AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7969 N8970DGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7970 N8971AAm Pm Services LLC - Adventure Series · Northbrook, ILBuilt 2004 · S/N 7971 N8974CSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7974

Back to AD 2002-22-13