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 ('2072406')
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 ('2072406')
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.
N8094XJenkins Matthew · Bend, ORN8095XBall Christopher B · Homer, AKN8097XKublank Nathan S · Sun Prairie, WIN8098XRaphael Christopher M · Colorado Springs, CON8101XBreuer Elizabeth · Horseshoe Bend, IDN8106XJones Wayne D · Huron, SDN8108XReding Joel M · Whittemore, IAN8111XPhillips Zachary T · Kettering, OHN8112XPeterson Michael D · New Richmond, WIN8122XRusty Flyer Aviation LLC · Grove City, OHN8124XNehrbass Douglas · Clarksville, TNN8125XBlue Skies Flying Services LLC · Blandon, PAN8127XBlick Clayton T · Dunedin, FLN8133XAdamie Isaac Sloan · Bowling Green, KYN8134XLugas Grant A · Elyria, OHN8135XMatarelli Robert E Jr · Carlton, MNN8136XStevenson George Otis · Wheatland, WYN8137XHarritt Roger · Anchorage, AKN8138XHarris David L · Wichita, KSFirst renewal noticeN8139XMerkle Patrick G · Washington, DCN8140XHubbell Carl · Crowley, TXN8142XWhitehead Daniel · New Providence, IAN8144XBeadles Scott D · Valley Springs, CAN8145XEast Carolina Aviation LLC · Camden, NCN8149XBlacksword Armoury Inc · Hawthorne, FLN8151XEvarts Raymond A · Cedar City, UTN8153XArmbrister Justin R · Blue Ridge, TXN8156XGoebel William · Rhome, TXN8157XRiverside Flight Academy LLC · Riverside, CAN8159XClydesdale Aviation LLC · Goodwater, ALN8166XWells Clinton M · Cincinnati, IAN8167XAbel Jacob · Bland, MON8169XHenderson George · Fresno, CAN8170XWhittington Melinda Sara Secrest · Columbus, OHN8172XVital Twyla J · Seguin, TXN8175XBeebe Shawn D · Ammon, IDN8176XCorrigan Walter E Jr · Seward, AKN8177XUnderground Aviation Group LLC · Elizabethtown, PAN8178XPaulsen Olaf · Clackamas, ORN8189XQuire Gregory L Sr · Shepherdsville, KYN8192XBryant Emily G DBA · Limestone, TNN8193XMarine Outlet Inc · Temple, TXN8196XDavis Joel A · Tunkhannock, PAN8200XKlad-Air LLC · Catlett, VAN8202XFerris Tyler S · Pompano Beach, FLFirst renewal noticeN8204XWallace Howard C · Lompoc, CAN8208XCompass Kitty Hawk LLC · Winneconne, WIN8212XMonahan Linda J · Groveland, CAN8214XStroemsvik Kristian · Strasburg, VAN8215XLaforest Jerome P · White Lake, MI
Back to Cessna 172B