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 ('2072502')
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 ('2072502')
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.
N9276BKinberger Chris E · Louisville, KYN9280BDreessen Steven C · Walkerton, INN9284BBeckley Larry · Scottsburg, INN9286BHall Leslie E · Lubbock, TXN9289BWoodstock Aircraft Services Inc · White Lake, NYN9290BFitts Roger W · Independence, ORN9291BVan Meerveld Dwight E · Poplar Grove, ILN9294BHall Justin E · York, NEN9295BTow Dogs LLC · Kingman, AZN9296BColby Robert D · Bigfork, MTN92DWBurnette Jeffrey T · Big Lake, AKN9300BBenson Ryan Denson · New Carlisle, OHN9305BStar Aero LLC · Santa Teresa, NMN9308BKorn Antony · Chehalis, WAN9310BThrom Donald R · Parachute, CON9315BVan Horne Robert E · Centralia, ILN9316BKnutson Wayne R · Thompson, NDN931URRegistration Pending · Ivins, UTRegistration pendingN9321BGippner Gerald W · Olathe, KSN9323BCarter Lance F · Bangor, CAN9328BDethlefs Darrell C · Mechanicsburg, PAN9329BSngdo Emergency Medicine Inc · Spring Hill, FLN9330BCarpenter Michael R · Wasilla, AKN9340BCook Raymond L · Spring Grove, ILN9341BYager Keith E · Eugene, ORN9343BBas Part Sales LLC · Greeley, CON9344BSumners David O Jr · Eastville, VAN9345BPasquariello Thomas · Alton, NHN9346BHarter Wayne R Jr · Alliance, OHN9350BHoman Ralph C · Weiser, IDN9354BC2 Aero LLC · Dallas, TXN9356BWard Clayton D · Mcville, NDN9359BPalinsky Gary C · Au Gres, MIN9360BWallace Joseph R · Winchester, KYN9361BPazsint Joseph J · Wasilla, AKN9365BPillar Mountain Airframes LLC · Palmer, AKN9366BStoots David A · Fairbanks, AKN9372BTomlin Trevor C · Huber Height, OHN9375BVinland Aerodrome Inc · Baldwin City, KSN9377BShanholtzer Shawn T · Palisade, MNN9378BKiser Courtney A · Woodbury, TNN9379BBravo Aviation LLC · Jasper, TXN9380BHarper Clayton E · Seabrook, TXN9384BReser Raymond E · Milton Freewater, ORN9388BCarr Kevin D · Columbia, MDN9389BWehr Michael R · Chugiak, AKN9391BCade Almon T · Bryceville, FLN9392BEddins Steven L · Lewiston, IDN9396BRhyshek John C · King Salmon, AKN9398BBishop Daniel R · Bettendorf, IA
Back to Cessna 175