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 ('2071816')
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 ('2071816')
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.
N4696XAval Aviation LLC · Las Vegas, NVN4700XCerasia Steven S · Amsterdam, NYN4704XHighsmith Michael D · Chipley, FLN4706XKey Joseph E · Eltopia, WAN4712XBludorn Matthew R · Bryan, TXN4714XHoffman Zachariah M T · Glendale, AZN4715XBlair Ross Iain · Milford, NJN4718XRobb James W · Uhrichsville, OHN4724XFlying My Dreams LLC · Miami Gardens, FLN4726XDoebler H Andrew · Myrtle Beach, SCN4727XN4727x LLC · Palmdale, CAN4730XDawson Allen J · Wshngtn Ct Hs, OHN4734XMclennon Daniel C · Boynton Beach, FLN4738XHageness Todd A · Rugby, NDN4739XKimberly Jack L · Shippensburg, PAN4742XMurphy Chong Yi · Fernandina Beach, FLN4749XFlaat Stephen C · Bemidji, MNN4750XSc Aircraft LLC · Copper Canyon, TXN4753XUpstate Flying Club Inc · Marcy, NYN4757XFountain John D Jr · Lynchburg, SCN4759XBaginsky D D · Salesville, OHN4762XSpatiumtech LLC · Madison, ALN4769XAnderson Aviation LLC · Erie, PAN4773XBlack Diamond Aviation LLC · Rathdrum, IDN4776XMersiowsky Richard R · King George, VAN4779XSnodgrass James T · Gallipolis, OHN4780XBroyles Dean L · Pittsboro, INN4781XMartinez Ivan A · Oro Valley, AZN4784XOgletree Ben R Jr · Livingston, TXN4789XGrald Jonathan A · Goshen, NYFirst renewal noticeN4791XBowden Wyatt D · Hamburg, ARN4795XHopkins Eric J · Wasilla, AKN4797XChadwell Letch J · Hulbert, OKN4799XBee Air LLC · Evansville, INN4800XHoistad Rick Allen · Forman, NDN4807XHile Daniel A · Clearfield, PAN4809XKc Aviation LLC · Kalispell, MTN4818XSchmitt Justin M · Shawneetown, ILN4823XVon Bernewitz David A · Myersville, MDN4824XPowell Kevin D · Nampa, IDN4827XPpy Fly Corp · Atlanta, GAN4828XGillette David L · Carrollton, TXFirst renewal noticeN4831XSeebold Dustin K · Mifflinburg, PAN4832XBaranski Charles J · New Windsor, NYN4834XTalluri Naga Hareesh · Round Rock, TXN4838XHannah Danny Lee · Elnora, INN4840XDel Valle Arnoldo · Sandia, TXN4842XKlemann Rose Marie · West Glacier, MTN4849XSeyfer Bradley W · Renton, WAN494RAAstra Integrated Technologies LLC · Rockledge, FL
Back to Cessna 150G