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.
N856PPWkair4 LLC · Boerne, TXN8577DAm Pm Services LLC · Northbrook, ILN857RWRepublic Airways Inc · Carmel, INN8580AAm Pm Services LLC - Alpha Series · Northbrook, ILN8587EAm Pm Services LLC - Alpha Series · Northbrook, ILN860RWUmb Bank Na Trustee · Salt Lake City, UTN861RWRepublic Airways Inc · Carmel, INN862RWRepublic Airways Inc · Carmel, INN863RWRepublic Airways Inc · Carmel, INN864RWRepublic Airways Inc · Carmel, INN8665AAm Pm Services LLC - Departure Series · Northbrook, ILN8672AAm Pm Services LLC Departure Series · Northbrook, ILN8694ASlate Crj Acquisitions 1 LLC · Johnstown, PAN871ASFrontera Flight Holdings Inc · Dover, DEN872BCBcc Aviation LLC · Dover, DEN873ASSkywest Airlines Inc · St George, UTN874ASCorporate Flight Management Inc DBA · Smyrna, TNN875ASCorporate Flight Management Inc DBA · Smyrna, TNN876ASSkywest Airlines Inc · St George, UTN877ASSkywest Airlines Inc · St George, UTN877HChallenger 5445 LLC · Allentown, PAN878ASSkywest Airlines Inc · St George, UTN879ASSkywest Airlines Inc · St George, UTN880ASSkywest Airlines Inc · St George, UTN880FCFawkescorp LLC · Lewes, DEN881ASSkywest Airlines Inc · Saint George, UTN882SFSuperior Aviation Inc Trustee · Orlando, FLN886ASSkywest Airlines Inc · St George, UTN888DHCanadair 5305 LLC · Dover, DEN888QLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8896AGold Coast Aviation · Fort Lauderdale, FLN889ASFrontera Flight Holdings Inc · Dover, DEN8908DSlate Crj Acquisitions 1 LLC · Johnstown, PAN890SARi Millennium I LLC · Beverly, MAN8944BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8948BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8970DGold Coast Aviation · Fort Lauderdale, FLN8974CSlate Crj Acquisitions 1 LLC · Johnstown, PAN898AKPoppa Air II LLC · Wellesley, MAN900EVSkywest Airlines Inc · St George, UTN901EVSkywest Airlines Inc · Saint George, UTN902AGT C Management Of Florida Inc · Naples, FLN902BResurrection House For All Nations Inc · Union City, GAN902EVSkywest Airlines Inc · St George, UTN902FJSkywest Airlines Inc · St George, UTN903EVSkywest Airlines Inc · St George, UTN904EVSkywest Airlines Inc · St George, UTN904FJSkywest Airlines Inc · St George, UTN905EVSkywest Airlines Inc · St George, UTN906FJSkywest Airlines Inc · St George, UT
Back to GE CF34 series