Registered aircraft · 299

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:2003-10-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:2003-10-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:2003-10-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:2003-10-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:2003-10-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:2003-10-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.

N100FNMeander Air II LLC · Moon Township, PABuilt 2008 · S/N RK-566 N101WRAtlantic Jet Partners LLC · Pompano Beach, FLBuilt 1991 · S/N RK-41 N106KHExecutive Air Solutions Corp · Fort Lauderdale, FLBuilt 2001 · S/N RK-323 N107CZPeri Jets Inc · Roanoke, VABuilt 2006 · S/N RK-462 N107SBN107sb Shares LLC · Liberal, KSS/N RK206 N1116RCtb Inc · Milford, INBuilt 1996 · S/N RK-116 N111FWAcme Management Co · Fort Worth, TXS/N RK-102 N112BJDg Group Aviation LLC · Bloomfield Hills, MIBuilt 1996 · S/N RK-112 N116ADStone Holdings LLC · Towson, MDBuilt 2002 · S/N RK-338 N119TCFlytat LLC · Missouri City, TXS/N RK-297 N124PPBec-Faye LLC · Grimesland, NCBuilt 1994 · S/N RK-92 N125DJN125dj LLC · Modesto, CABuilt 2007 · S/N RK-531 N127EJExecutive Air Solutions Corp · Fort Lauderdale, FLS/N RK-127 N12XPXpress-Air LLC · Cortland, NYS/N RK-458 N130WWWidewaters Beechjet Aviation LLC · East Syracuse, NYBuilt 1997 · S/N RK-136 N150RSRsa LLC · Myrtle Beach, SCS/N RK-373 N154DJWhw Transportation LLC · Jacksonville, FLBuilt 1997 · S/N RK-175 N156RKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N RK-156 N157PWRk264 LLC · La Porte, INBuilt 1999 · S/N RK-264 N175CCClemens Aviation LLC · Wichita, KSBuilt 2000 · S/N RK-277 N179TAExecutive Air Solutions Corp · Fort Lauderdale, FLBuilt 2016 · S/N RK-447 N186CMTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N RK-248 N188HALouisville Aircraft Leasing LLC · Sellersburg, INBuilt 1997 · S/N RK-164 N188JFHawkerblue LLC · Santa Ana, CAS/N RK-446 N188THPyraminx Logistics LLC · Kalispell, MTBuilt 1999 · S/N RK-244 N191TPAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2008 · S/N RK-574 N1980EWoodburn Aviation LLC · Moon Township, PAS/N RK-444 N199TTCentral Iowa Aviation LLC · Ankeny, IABuilt 2008 · S/N RK-550 N1AGGossett Aviation LLC · Memphis, TNBuilt 2008 · S/N RK-489 N203DFFast Air LLC · Liberal, KSBuilt 1998 · S/N RK-203 N209BKRyffel Aviation LLC · Fort Worth, TXBuilt 1997 · S/N RK-137 N215JLJaw A1r LLC · Kitty Hawk, NCBuilt 2008 · S/N RK-549 N217ECBank Of Utah Trustee · Salt Lake City, UTS/N RK-356 N21PJSky Aviation Holdings LLC · Pompano Beach, FLBuilt 1999 · S/N RK-240 N222JYHigher Cause Too LLC · Grand Rapids, MIBuilt 1990 · S/N RK-4 N224FDN224fd LLC · Boca Raton, FLS/N RK-324 N225SBEncore Jet Management LLC · San Antonio, TXBuilt 2007 · S/N RK-510 N228SBJet Shares LLC · Liberal, KSBuilt 1999 · S/N RK-224 N233MWMammoth Jets 1 LLC · Rancho Santa Fe, CABuilt 1999 · S/N RK-233 N237SPSky Aviation Holdings LLC · Pompano Beach, FLBuilt 1991 · S/N RK25 N25341Southwest Tech Center · Altus, OKS/N TT-55 N257EBHusker Aviation LLC · Casper, WYBuilt 2007 · S/N RK-517 N258EBRaviation LLC · Orem, UTBuilt 1996 · S/N RK-129 N25CUGrove City Aviation LLC · Mercer, PAS/N RK-361 N260JRCentral Iowa Aviation LLC · Ankeny, IABuilt 2004 · S/N RK-394 N262TXEverair LLC · Naples, FLBuilt 2006 · S/N RK-464 N287LSBeech Transportation Inc · Eden Prairie, MNBuilt 2005 · S/N RK-425 N29134Airhead Aviation LLC · Jacksonville Beach, FLS/N RK-484 N300GBAmc Charters Inc · Lake Worth Beach, FLBuilt 1999 · S/N RK-262 N302TBMoser Aviation LLC · Englewood, COBuilt 2004 · S/N RK-384

Back to AD 2003-10-13