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.
N5472RAnderson Craig D · Mission Viejo, CAN5475HRouth Frank D · Marion, NCN5479RLott Brian K · Nixa, MON5485HGiron Lawrence · Anchorage, AKN5490HSuperior Flying Services LLC · Superior, WIN5491HSky Hogs LLC · Orange Park, FLN5492HAcme Aircraft Flying Club LLC · Kalispell, MTN5496HWilson Charles L · Seattle, WAN5498HGulf Atlantic Airways Inc · Gainesville, FLN54PRReimer Lynn C · Sioux Falls, SDN555CVAviation Paradise LLC · Homestead, FLN555SLHuffman Jacob M III · Burleson, TXN555SMWalla Walla University · College Place, WAN557DJMclain Aviation LLC · Lyons, GAN560ZHeslin Jon P · Sutton, MAN561DEFlynn John M · Martinez, CAN561ZDelgado-Ocasio Brunilda · Patillas, PRN56DGEagle East Aviation Inc · North Andover, MAN56FAir Kings LLC · West Chester, PAN56MWHeartland Ag Aviation LLC · Lancaster, KSN572RJUniversity Of Michigan Flyers Inc · Ann Arbor, MIN574DEMuggsys Aviation Services LLC · Crittenden, KYN579JKKopacz Thomas H · Glen Flora, WIN57BMHuerta Holdings Inc · Santa Ana, CAN57WHMoon Richard B · Arizona City, AZN5983MPhilipp Michael W · Thief River Falls, MNN5CMBramall Buster I · Waxahachie, TXN600VVMindy Limited LLC · Muscatine, IAN602JYN13303 LLC · Miami, FLN609DCBarber Aircraft LLC · Topping, VAN60HEagle Flight Squadron Inc · East Orange, NJN60YGLindstrom Dave C · Marinette, WIN610ACHybird Inc · Corpus Christi, TXN611BDClement Aviation Inc · Tea, SDN61531Aero Maintenance Inc · Vancouver, WAN61534Registration Pending · Cheney, KSRegistration pendingN61536Aerolanding LLC · Enterprise, ALN61539N61539 LLC · Arvada, CON61544Knudsen Russell G · East Troy, WIN61547Frontline World Missions Inc · Jacksonville, TXN61548Adamson Daniel A · Moscow, OHN61557Angle Of Attack LLC · Boise, IDN61565Fly565 LLC · Richmond, KYN61566Modin John · El Dorado Hills, CAN61567Enzyme Holdings LLC · Wilmington, DEN61571Engineers Flying Club Inc · Bethany, OKN61573Registered aircraftN61574Bruns Michael Wesley · Scottsdale, AZN61577Ingle Daniel B · Coraopolis, PAN61581Brat Equipment Co LLC · Slinger, WI
Back to Cessna 172M