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 ('2072702')
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 ('2072702')
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.
N5757BWilson Chad R · Port Angeles, WAN5758BBentley John · Bend, ORN5760BAbbott Jay D · Rocky Mount, VAN5761BTerry Canales Attorney At Law Pllc · Edinburg, TXN5765B5765 Bravo LLC · Three Forks, MTN5766BClover Crest II Inc · Key Largo, FLN5767BBarker Ski LLC · Anchorage, AKN5769BOgorman Errol M · Festus, MON5771BMorris Jerry W · Deer Trail, CON5774BAshiku Phillip · Ukiah, CAN5775BBrindley Paul A · Plainwell, MIN5776BTjp@Jax Inc · Zephyrhills, FLN5777BScrews Elisha J · Owens Cross Roads, ALN5781BRobinson Stephen L · Celina, TXN5782BRankin Paul D · Hudson, WIN5783BGlaser Edwin P · Calhan, CON5784BC&B Aerial Transport Inc · Wilmington, DEN5785BWoodley Aerial Leasing LLC · Walnut, ILN5791BQuist Michael A · Antioch, ILN5792BJacquin Aviation Inc · Markham, ILN5793BRitland Stephen · Flagstaff, AZN5795BJst Management LLC · Zephyrhills, FLN5803BMccole Kevin · Brookline, NHN5804BShoemaker Mark T · Springfield, ORN5812BAxis Equipment LLC · Fuquay Varina, NCN5813BReese Phillip D · Morristown, TNN5815BOff The Step Inc · Creswell, ORN5817BMiller Harold A · Susanville, CAN5818BDeal Thomas J · Seattle, WAN5819BBoston Skydive Center LLC · Albion, RIN5822BHubbell Coy J · Sonoita, AZN5824BPritchard Joshua Corey · Carey, IDN5826BGiger Janice F · Weston, ORN5829BFair Skies Inc · Dade City, FLN5830BHaberich Alexander J · Avon, CON5832BAircraft Structural Repair Inc · Hamilton, MTN5835BJepson Duwayne D · Frazee, MNN5839BReffett John S · Eagle River, AKN5841BFultz Wilbur R · Fort Benton, MTN5842BPietrs Michael · Shoreview, MNN5953BElevate Air Inc · Titusville, FLN5GSOllman Matthew P · Poplar Grove, ILN611GDufriend Daren P · Payson, AZN6206ANipper James R · Defuniak Springs, FLN6207ABtp Inc · Missoula, MTN6210ADepot Avionics Inc · Alamosa, CON6211ASaulsberry Regor L · Datil, NMN6213AHerbert Ronald J · Anchorage, AKN6214ASkydive Cape Cod Inc · Caddo Mills, TXN6215AC & B Aerial Transport Inc · Wilmington, DE
Back to Cessna 182