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 ('30015')
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 ('30015')
ORDER BY n_numberRun 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.
N813JATrademark Aviation LLC · Camden, DEN813LSLove Airlines LLC · Dallas, TXN813MSCypress Cove Air LLC · Phoenix, AZN814PSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN815MDUmb Bank Na Trustee · Salt Lake City, UTN818AFCorbin Aviation LLC · Durant, OKN818MDUmb Bank Na Trustee · Salt Lake City, UTN819AYSlate Crj Acquisitions 1 LLC · Johnstown, PAN820ASBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeN820AYSlate Crj Acquisitions 1 LLC · Johnstown, PAN821AYLogos Aviation Inc · Fort Lauderdale, FLN823AYFrontera Flight Holdings Inc · Dover, DEN823KDEast Shore Aviation LLC · Fort Lauderdale, FLN823MDUmb Bank Na Trustee · Salt Lake City, UTN824AYBeautech Power Systems LLC · Dallas, TXN824MDUmb Bank Na Trustee · Salt Lake City, UTN825AYFrontera Flight Holdings Inc · Dover, DEN825SGPlane Fetch Charter LLC · Anaheim, CAN826AYSlate Crj Acquisitions 1 LLC · Johnstown, PAN827AYLogos Aviation Inc · Fort Lauderdale, FLN828WGWg Aero LLC · Anchorage, AKN829AYFrontera Flight Holdings Inc · Dover, DEN831AYBeautech Power Systems LLC · Dallas, TXN832AYBank Of Utah Trustee · Salt Lake City, UTN8390ADelta Air Lines Inc · Atlanta, GAN83UFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8409NDelta Air Lines Inc · Atlanta, GAN8416BDelta Air Lines Inc · Atlanta, GAN843GSReserve Aircrafts LLC · New York, NYN8458ALogos Aviation Inc · Fort Lauderdale, FLN845ASDodson International Parts Inc · Rantoul, KSN845SASlate Crj Acquisitions 1 LLC · Johnstown, PAN8492CDelta Air Lines Inc · Atlanta, GAN8495BDelta Air Lines Inc · Atlanta, GAN8501FDelta Air Lines Inc · Atlanta, GAN8505QAm Pm Services LLC - Blue Sky Series · Northbrook, ILN8506CAm Pm Services LLC - Blue Sky Series · Northbrook, ILN8515FAm Pm Services LLC - Series One · Northbrook, ILN8516CAm Pm Services LLC- Blue Sky Series · Northbrook, ILN851GKKkh Rentals Inc · San Antonio, TXN8525BAm Pm Services LLC - Blue Sky Series · Northbrook, ILN8532GAm Pm Services LLC- Blue Sky Series · Northbrook, ILN8533DAm Pm Services Llcblue Sky Series · Northbrook, ILN8541DAm Pm Services LLC - Blue Sky Series · Northbrook, ILN854ASSkywest Airlines Inc · St. George, UTN8554AAm Pm Services LLC - Blue Sky Series · Northbrook, ILN855MMMarklyn Jet Parts LLC · Dallas, TXN855RWRepublic Airways Inc · Carmel, INN8560FAm Pm Services LLC - Blue Skies Series · Northbrook, ILN856ASSkywest Airlines Inc · St George, UT
Back to GE CF34 series