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 ('2072418')
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 ('2072418')
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.
N5034HHernandez Dorothy V · Juneau, AKN5037RJlinn Aviation Inc · Quinlan, TXN5039HBig Mountain Aviation Inc · Whitefish, MTN5039RSmooth Landings Inc · Cary, ILN503CAThompson Paul W Jr · Yachats, ORN503MAHobart Aviation Inc · Akron, OHN503WAThree Rivers Aero Inc · Three Rivers, MIN5040RShirley Craig T · Ennis, MTN5041HSimplifly LLC · Mesa, AZN5042RLemieux Michael H · Methuen, MAN5043RRegistered aircraftN5044HCoogan Dennis P · Madison, WIN5044RSouth Bay Flight Training Center · Carolina, PRN5045HGrabofsky Livestock & Grain Inc · Hogeland, MTN50462Weekley Clint · Manvel, TXN50479Alvarez Randolph Clarence · Igiugig, AKN50484Freudenthal Jack J · Medford, WIN50485Wiedeman Douglas J · Springboro, OHN5048RSandeep Sharma LLC · Oshkosh, WIN5049RIndiana Paging Network Inc · La Porte, INN5051RSkywarrior Flight Training LLC · Pensacola, FLN50523Koch Allen William · Anchorage, AKN5054HParker James C · Cuthbert, GAN5055HShaka Skies LLC · Kihei, HIN5055RGreat Lakes Air Ventures LLC · Mason, MIN5057HAjf Enterprises LLC · Des Moines, IAN5057RHeise Roger H · Clayton, NYN50590Usaeroflight LLC · Greenville, SCN5062RRichland County Finance Department · Columbia, SCN5063HParsons William L · Harrogate, TNN5064HFranklin Air Services LLC · New Orleans, LAN5066RBurke William M · Norwalk, CTN5067HSanders Flight Training Center Inc · Jasper, ALN5069HNehring Curtis A · Goleta, CAN5071HFosse David K · Carbondale, ILN5072HRiebeling Eric Herbert · Reno, NVN5073HElite Planes LLC · Menifee, CAN50762Skyhawk Group · Kent, WAN5076NJb Aviation Flight School Inc · Wonder Lake, ILN5078RBlue Goose Aviation Inc · Polson, MTN5082RWings Over Texas Holdings LLC · Denton, TXN5084RBenham Eric T · Las Vegas, NVN50864Rasmussen Agribusiness Inc · Antelope, MTN5086RSafety In Motion Flight Center Inc · Puyallup, WAN5088RGlacier Equipment LLC · Wasilla, AKN5089RHigh Wing Air Services LLC · Merritt Island, FLN5093RSkyhawks Inc · Montoursville, PAN50941Labrucherie Peter E · El Centro, CAN50944Munoz Jacqueline T · Huntsville, ALN50947Bend Aircraft Mechanics LLC · Bend, OR
Back to Cessna 172M