Skip to content

C F E CFE-738-1-1B

Registered aircraft · 73

Aircraft with this engine in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE engine_model_code IN ('16800')
  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, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('16800')
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.

N105AFAir4 Aviation LLC · Houston, TXBuilt 1995 · S/N 012 N114EMBsycbm LLC · Delray Beach, FLBuilt 1999 · S/N 90 N122VRWest Texas Holdings LLC · San Antonio, TXBuilt 2000 · S/N 122 N123PDDooney & Bourke Inc · East Norwalk, CTBuilt 1995 · S/N 19 N181GD330am Holding Corp · Miami, FLBuilt 2001 · S/N 133 N192HAWhite Diamond Row LLC · Hackett, ARBuilt 1998 · S/N 061 N2000LMl Fare LLC · Newark, DEBuilt 1999 · S/N 109 N203AFAir4 Aviation LLC · Houston, TXBuilt 1994 · S/N 003 N214LDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 41 N234FJAlfonso Media Logistics LLC · Miami, FLBuilt 1996 · S/N 34 N250WJEastview Av Partners I LLC · Kings Point, NYBuilt 1999 · S/N 85 N25VRN25vr LLC · Portland, ORBuilt 2001 · S/N 152 N26NJAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 139 N277XXBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 177 N27AFAir4 Aviation LLC · Houston, TXBuilt 1997 · S/N 45 N285KKHaystack 204 LLC · Portland, ORBuilt 2002 · S/N 204 N286CXPinnacle Assurance LLC · Tampa, FLBuilt 1999 · S/N 102 N301AFAir4 Aviation LLC · Houston, TXBuilt 1996 · S/N 44 N317MNext Level Marine LLC · Mount Pleasant, TXBuilt 2002 · S/N 188 N325GMRegistration Pending · Salt Lake City, UTRegistration pendingBuilt 2001 · S/N 164 N330KJet Sense Aviation Aircraft Holdings Corp · Lake Zurich, ILBuilt 2002 · S/N 189 N360DMMaund Doug · Austin, TXBuilt 2003 · S/N 210 N364AEHayden Gray LLC · Dallas, TXBuilt 1997 · S/N 036 N365TX235jb LLC · Lewes, DEBuilt 1998 · S/N 56 N368MBAffiliated Investments LLC · Auburn Hills, MIBuilt 2001 · S/N 161 N37MDTriangle Aviation LLC · Dover, DEBuilt 1996 · S/N 32 N40THKl Air LLC · Mooresville, NCBuilt 2001 · S/N 007 N413HAMap Transport LLC · Lexington, KYBuilt 2001 · S/N 147 N420CCCooke & Cooke Air LLC · Nashville, TNBuilt 1996 · S/N 40 N42STTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 39 N435JFJf Aircraft LLC · Detroit, MIBuilt 1997 · S/N 47 N468AMAmc 50 LLC · Chicago, ILS/N 074 N470MKBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 146 N48FBWkc Corp · St Louis, MOBuilt 1995 · S/N 11 N48MFAm Specialty Insurance Co · Dallas, TXBuilt 2000 · S/N 115 N504WTHerin Aviation LLC · Spring, TXBuilt 2019 · S/N 062 N506DJJrw Falcon LLC · Staten Island, NYBuilt 2001 · S/N 158 N507DJFirm Foundation Aviation LLC · Brea, CABuilt 2001 · S/N 162 N508DJBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2001 · S/N 165 N513DJCccnj F2000-169 LLC · Windermere, FLBuilt 2002 · S/N 169 N513KDKd Aviation 51 LLC · Portland, ORBuilt 2002 · S/N 184 N516DGFalcon Air LLC · Los Angeles, CABuilt 2000 · S/N 116 N518SSFalconsn100 LLC · Roslyn, NYBuilt 1999 · S/N 100 N519JDDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N 198 N53NJLear 100kz LLC · Burnet, TXBuilt 2002 · S/N 174 N553GRRivers Edge Equipment Leasing LLC · Springfield, ILBuilt 1998 · S/N 64 N555GSInvestjet LLC · Miami, FLBuilt 2001 · S/N 149 N613BDLynx Medical Transport LLC · Cincinnati, OHBuilt 2004 · S/N 218 N623HDK & M Aviation Holdings I LLC · Hartville, OHBuilt 1996 · S/N 35 N627LGLive Mas Enterprises LLC · Greenwood Village, COBuilt 1995 · S/N 14

Back to C F E CFE-738-1-1B