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 aircraft_model_code IN ('9230104')
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 aircraft_model_code IN ('9230104')
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.
N78276Registered aircraftN78277Belcher Wesley Jay · Fawn Grove, PAN78279Ulmer Bryce D · Locust Grove, GAN78280Stroud Richard M · New Market, ALN78282Harrington Michael R · Locust Grove, GAN78288Simmons William E · Port Orchard, WAN78290Mclellon Richard Steven · Littleton, CON78310Huang Sophie M · Newcastle, WAN78311Rey Henry R · Fresh Meadows, NYN78315Breese William R · Omaha, NEN78317Silveria Frank R · Los Banos, CAN78320Zoom Leasing LLC · Barto, PAN78321Yak Training LLC · Mansfield, TXN78324Langman Greg K · Manitowoc, WIN79KMabry William L · Bluffton, SCN7BLWilson Stephen A · Granbury, TXN801JFWarbird Leasing LLC · Santa Fe, NMN80500Swift Museum Foundation Inc · Athens, TNN80528Mastalerz Peter W · Monson, MAN80545Smith William N · Vilonia, ARN80550Mcdonald Alan D · Amador City, CAN80551Lenz Frank M · Boca Raton, FLN80555Stahla Russell A · Girdwood, AKN80564Weaver Tracey L · Cushing, OKN80571Western Carolina Aviation LLC · Andrews, NCN80572Gettelfinger Jane L · Fort Myers, FLN80591Lakala Aviation Inc · Vicksburg, MIN80600Gores Thomas J · Franklin, WIN80603Ellingham Jeffrey B · Perry, GAN80611Marrs Aircraft Repair Recovery Sales LLC · Lake Placid, FLN80614Jenkins Susan · Pima, AZN80615Permian Basin Blue Sky Medical Supply Inc · Odessa, TXN80622Lam Lawrence Y · Rosemead, CAN80630Green David J · Beaufort, SCN80637Brown Bear Haven LLC · Anchorage, AKN80644Mccarty Keith · Huntsville, TXN80647Cc Motors LLC · Redding, CAN80649Red Arrow Aviation LLC · Santa Teresa, NMN80654Peacock Robert E · Cochran, GAN80658Stalker Allen R Sr · New Marlborough, MAN80665King Ludlow III · Potomac, MDN80671Fleurent Ronald G · Biddeford, MEN80675Irvine Paul E · Antioch, CAN80676Ozarks Auto Show Inc · Hollister, MON80680Leaders Bob · Clear Lake, MNN80687Peraro Thomas A · Brighton, CON80689Vonsalzen Carsten K · Grants Pass, ORN80694Auburg George Randell · Midland, TXN80707Halladay Roy · Erie, CON80710Bartholomew Don · Gardnerville, NV
Back to Globe GC-1B