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 ('2072434')
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 ('2072434')
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.
N5720EInstall Pro Construction LLC · Henderson, NVN5724JPurdue Aviation LLC · West Lafayette, INN5727EZeitvogel Jeanine · Gulf Shores, ALN5730JLindley Field Flying School LLC · Greensboro, NCN5732EWynn Josh · Bucyrus, OHN5748EInternational Air Services Inc Trustee · Carson City, NVN5751EFlight Tech Inc · Arlington, WAN5754ECox Charles C · Hood River, ORN5757EFlex Air Inc · San Diego, CAN5758JBatchelder Wesley · Palacios, TXN575TDDahl Russell · Nashua, MTN5763EVilla Rafael O · Miami, FLN5766JVan Hoogmoed Andrew P · Turlock, CAN5782JN5782j LLC · Myrtle Beach, SCN5803EIrwin Donald L · Emporia, KSN5811EMoss Jessee C · Ardmore, OKN581ESQuinby Alan D · Woodward, OKN5832JAerial Advertising Services · Livermore, CAN5833JAlbatross Air Inc · Beaver, WVN5878ESouthern Aircraft Consultancy Inc Trustee · Casper, WYN5880ENashville Skyscrapers LLC · Old Hickory, TNN58DSBalliet Edgar J III · Northampton, PAN58TYJohnson Jake M · Texarkana, TXN5907ERiver City Flying Club Inc · Valley Center, KSN5909EOwens Flight Training LLC · Lafayette, LAN5916JUnited States Air Force - Owner · Eglin Afb, FLN5922EAerial Scouting Solutions LLC · Sioux Center, IAN5928EGace Flying Club Inc · Ronkonkoma, NYN5943EPlane Zane LLC · Stuart, FLN5948ETlt Legacy LLC · Fort Worth, TXN5951ELlano Alfonso · Tucson, AZN5955EClover Park Technical College · Tacoma, WAN5956EWalsh James · Hayden, IDN5976EFunkhouser Dennis E · Fredericksburg, VAN597DMBrandon Air LLC · Valley Stream, NYN5983JIlarraza Gilberto C · Sabana Hoyos, PRN5990EManeuvering Speed Inc · Wilmington, DEN5993ETss Flying Club Inc · Bethesda, MDN5AKHackler Tara Cole · Bend, ORN601PAMendenhall Michael L · Douglasville, GAN6031EHigh Exposure Inc · Wilmington, DEN6063ELawrence Aviation LLC · Overland Park, KSN6083JB&R Aircraft LLC · Wadsworth, OHN6086GAbovestandard LLC · Denison, TXN6091DMentone Flying Club · Rochester, INN6092FJasper Aviation Inc · Jasper, ALN6093JAir S & T LLC · San Juan Capo, CAFirst renewal noticeN6094FBuiqui Aerospace Corp · Kissimmee, FLN6098DShurtleff Russell D · Tunkhannock, PAN60GAGlidewell Aviation Inc · Parkland, FL
Back to Cessna 172N