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 ('59470')
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 ('59470')
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.
N776APMagee Jeff · Mccall, IDN791WDavis Joseph R · Fulton, MON811XXGold Star Aviation Inc · Salisbury, NCN812CCBarth Florian M · Los Gatos, CAN819TRDrewster LLC · Boynton Beach, FLN821NDRainbow Aviation Services · Kingsville, MON822JBFandango Ranch Operating Co Inc · Bend, ORN825MEPlane Company LLC · Greenbrier, TNN82BEPa Prospect Corp · Columbus, MTN82LGBlankenberger Patrick · Poseyville, INN83XPNafus Gifford W · Palmer, AKN865CMMandes George J · Homer, AKN87DHMoriarty Trucking LLC · Weippe, IDN883WBrennan Daniel M · Platteville, CON889GXAero Assurance Services LLC · Yakima, WAN905MBTerral William L · Bush, LAN907CMMandes George J · Homer, AKN907GBAk Cubs LLC · Anchorage, AKN907GMMandes George · Homer, AKN913DMWingnut Aviation LLC · Fort Lupton, CON923SYYoung Steven · Redmond, ORN926SDHollingsworth Rusty · Pierre, SDN946KF60kf LLC · Boonton, NJN964KDCc964 LLC · Boynton Beach, FLN9693XJamb LLC · Yakima, WAN97JJDanville Aviation Services LLC · Lancaster, KYN983CCBoardman Air Service LLC · Henderson, NEN9FZFosdick William P · Bumpass, VA
Back to Titan OX-340CC