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.
N266AVBank Of Utah Trustee · Salt Lake City, UTN267DFUS Trinity Equipment LLC · Argyle, TXN27173Wells Fargo Trust Co Na Trustee · Salt Lake City, UTN275KH75 Express Inc · Mooresville, NCN28BQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN290SASlate 290 LLC · Johnstown, PAN29CUImagicomm Enterprises LLC · Charlotte, NCN309WBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN317CADelta Air Lines Inc · Atlanta, GAN318JGJuliet Golf LLC · Bloomfield Hills, MIN320SGRegistered aircraftAssigned (import), pending cancellationN322LVBig Rapids Products Aviation LLC · Big Rapids, MIN327TWEmily Aviation LLC · Madison, NJN329MDUjm I LLC · Naples, FLN331CADelta Air Lines Inc · Atlanta, GAN340AK2fast Aviation LLC · Wilmington, DEN340CADelta Air Lines Inc · Atlanta, GAN354CADelta Air Lines Inc · Atlanta, GAN355CADelta Air Lines Inc · Atlanta, GAN359VValmont Industries Inc · Omaha, NEN367CADelta Air Lines Inc · Atlanta, GAN368CADelta Air Lines Inc · Atlanta, GAN36VVRedgate Partners LLC · Whittier, CAN37178Bank Of Utah Trustee · Salt Lake City, UTN371CADelta Air Lines Inc · Atlanta, GAN374CASkywest Airlines Inc · Saint George, UTN376CADelta Air Lines Inc · Atlanta, GAN379CADelta Air Lines Inc · Atlanta, GAN390CADelta Air Lines Inc · Atlanta, GAN391CADelta Air Lines Inc · Atlanta, GAN396SAMard Aviation LLC · Johnstown, PAN398CADelta Air Lines Inc · Atlanta, GAN405AWAir Wisconsin Airlines LLC · Appleton, WIN405HBCitation Aviation LLC · Oklahoma City, OKN407SWBank Of Utah Trustee · Salt Lake City, UTN408AWAir Wisconsin Airlines LLC · Appleton, WIN409AWCsi Aviation Inc · Killeen, TXN40UTBadlands Leasing LLC · Wilsonville, ORN410AWAir Wisconsin Airlines LLC · Appleton, WIN411ZWUmb Bank Na Trustee · Salt Lake City, UTN412AWAir Wisconsin Airlines LLC · Appleton, WIN413AWAir Wisconsin Airlines LLC · Appleton, WIN413SWBank Of Utah Trustee · Salt Lake City, UTN414ZWAir Wisconsin Airlines LLC · Appleton, WIN415AFAmerica Fujikura Ltd · Duncan, SCN415AWCsi Aviation Inc · Killeen, TXN416AWCsi Aviation LLC · Killeen, TXN417AWUmb Bank Na Trustee · Salt Lake City, UTN418PPGranger J Weldon · Houston, TXN419AWAir Wisconsin Airlines LLC · Appleton, WI
Back to GE CF34 series