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.
N601QAQuality Aircraft Sales Inc · Boca Raton, FLN601TPPyle Group LLC · Madison, WIN601VRN560bl LLC · Orlando, FLN604AUBank Of Utah Trustee · Salt Lake City, UTN604AVAero Ventures 5 LLC · Torrington, CTN604BBMa Aviation LLC · Fargo, NDN604BCWpc Holdings LLC · Fort Lauderdale, FLN604CRUS Auto Finance Leasing LLC · Wilmington, DEN604DTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN604EMRegistered aircraftN604FMBlue Five LLC · Omaha, NEN604GFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN604GWCfc LLC · Bloomington, INN604HMHarbert Aviation LLC · Birmingham, ALN604HSHsl II LLC · Tampa, FLN604KJNew Kpc Holdco LLC · Fort Lauderdale, FLN604LASwallow Acquisitions LLC · Wilmington, DEN604MN604m LLC · Scottsdale, AZN604MBChallenger 601 Holdings LLC · Missoula, MTN604MHRegistered aircraftN604MTDodson International Parts Inc · Rantoul, KSN604PSBank Of Utah Trustee · Salt Lake City, UTN604PVStallion Aviation II LLC · Roseland, NJN604RBLouisiana Aviation LLC · Whitefish, MTN604RMFireproof Aviation LLC · Southfield, MIN604SBKhosla Ventures LLC · Menlo Park, CAN604SGGaf Holdings Inc · Visalia, CAN604WBChoice Administrators Insurance Services Inc · Orange, CAN604ZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN605JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN609SKSkywest Airlines Inc · St George, UTN610LValiair Lc Trustee · Casper, WYN611ABPollard Spares LLC · Roanoke, TXN611SKSkywest Airlines Inc · St George, UTN612QXSkywest Airlines Inc · St George, UTN613SKSkywest Airlines Inc · St George, UTN614QXSkywest Airlines Inc · St George, UTN614SKSkywest Airlines Inc · St George, UTN618JJJj Challenger 620tm LLC · Wilmington, DEN620PJFth Acquisition Corp Vii · Richardson, TXNon-citizen corporation, flight hours not reportedN621DJNorth Point Aviation LLC · San Francisco, CAN625CASkywest Airlines Inc · St George, UTN627AFAmerican Fidelity Corp · Oklahoma City, OKN628EFSn 5024 Corp · Fort Lauderdale, FLN629SYSkywest Airlines Inc · Saint George, UTN638RWRepublic Airways Inc · Carmel, INN639RWRepublic Airways Inc · Carmel, INN640GRDodson International Parts Inc · Rantoul, KSN640RWRepublic Airways Inc · Carmel, INN641CADelta Air Lines Inc · Atlanta, GA
Back to GE CF34 series