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 ('05901RL', '05901QZ', '05903AF')
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 ('05901RL', '05901QZ', '05903AF')
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.
N119WMBartu Leroy Richard · Pocatello, IDN1204SSchlautmann Joseph W · Gillette, WYN1299WMyers Joey M · Fairfield, CAN1562Williams Timothy A · Lyons, ORN16633Hurkes David A · Watertown, SDN168FLSterner Robert T · Fort Walton Beach, FLN196MWEverett Gary L · Aurora, MEN20419Bess James V · Sequim, WAN208WGGrusik William A · Union, MEN2479SCarlson James M · Milbank, SDN2514GMiller Dennis J · Glenview, ILN2541UDorsey James M · Brooklyn, WIN2614WKelly William P · Wautoma, WIN2630TPittman Stuart P · Palisade, CON2645PDawson John H · Claremore, OKN3135THejtmanek Donald L · Kindred, NDN327MKKlem Michael J · New Braintree, MAN4047BRound Trip Lc · Elkhart, KSN41079Hilderbrant William DBA · Dansville, NYN477ZBisig John A · Elba, NYN5132JLipman Barry Jay · Hauppauge, NYN524LMcpherson Kenneth · Conway, NHN52WGGius William J · Fond Du Lac, WIN5514YDoucette Perry J · Sugar Grove, ILN5604GLutz Tony M · Hickory, NCN5608PTanner David M · Eden, UTN5617XLoenser James A · Clayton, WIN6126XSay Douglas A · Farr West, UTN619DMMoulton Donald E · Bunker Hill, ILN6365ALeverton James F · Cannon Falls, MNN65736Clare Alan V · Maiden Rock, WIN66095Berg John · Sand Springs, OKN666TJSimeon Jim · Ogallala, NEN7056LMeeks Donald W · Como, TXN7099JSavio Dominic · East Patchogue, NYN7113JVandegrift David H · Saint Paul, MNN7123VAutrey Randy D · Bethel, MEN7155BPaddock Douglas O · Arlington, NEN75464Elkins Lyndol L Jr · Alburgh, VTN8003VSchafer Daniel J · Oviedo, FLN8039QSoroko Edward J · Kingman, AZN8045ZBoyd James G · Killen, ALFirst renewal noticeN84PMLockhart John P · Mapleton, MEN9326XLove William E · Round Top, TXN94495Mansfield Harold R · Fenton, MON9451VWhitney Richard B · North Brookfield, MA
Back to Six Chuter SR7 XL