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 ('2073456')
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 ('2073456')
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.
N210P210p LLC · Kalispell, MTN210PATrejo Nahomy · Socorro, TXN210PJNickels Raymond E · Loxahatchee, FLN210PKBeam Construction Nv LLC · Zephyr Cove, NVN210PWPapa Whiskey Aviation LLC · Huntsville, ALN210RBLibrary Interiors Of Florida Inc · Auburndale, FLN210SDArdoin Robin C · Lafayette, LAN210SSVucich Bryant · Palm Beach Gardens, FLN210TGDouble H Enterprises LLC · Bolivar, MON210TJJaco Oil Company · Bakersfield, CAN210TPAirborne Enterprises LLC · Ava, MON210VBHoogendyk Robert · Big Bear City, CAN210VJV J Wings Inc · Wilmington, DEN210VVHeesacker Stephen L Trustee · Los Altos, CAN210WCWeeks Curtis E · Cotulla, TXN210WJRude Daniel · Leesburg, VAN211CFGoudreau Sean · Mount Dora, FLN211LR & G Schatz Farms Inc · Lockeford, CAN212TSParkside Automotive & Truck Service · Mountain Top, PAN2134UDean Steel Buildings Inc · Fort Myers, FLN218CCSotally Tober LLC · Wilmington, DEN220TJJaco Oil Co · Bakersfield, CAN222SGPacific Aviation Aircraft Management Inc · Fresno, CAN224KAChambers William Melvin Jr · Azle, TXN224PKValiair Lc Trustee · Casper, WYN2306DUS Navy - Owner · Jacksonville, FLN2340UTex-Pan Aviation Inc · Amarillo, TXN235WJmzb Leasing LLC · Amarillo, TXN2437UPlanetosea LLC · Doylestown, PAN24NHBeyer Roger · Paw Paw, MIN252SWSymns Robert A · Aguila, AZN274HAPacific Rain Inc · Arroyo Grande, CAN283RDBengtson Douglas Richard · Woodinville, WAN300HCPs Air LLC · Evansville, INN308BCMike Kilo Foxtrot LLC · Wilmington, DEN30HDRegistered aircraftN30VGGeoterra Inc · Eugene, ORN312SCBarker Family Investments Management Co LLC · Tyler, TXN316RWFour States Tire & Service Inc · Cortez, CON321BPCenturion Air Inc · Ridgewood, NJN32331Sowers Richard M · Reno, NVN323DASky West Aviation Inc Trustee · Albuquerque, NMN331CBN331cb LLC · Great Falls, MTN344AJQualitair LLC Trustee · MichelstadtN355YPlussa Mark George · Clermont, FLN369HCCornerstone Mapping Inc · Roca, NEN38PFSycan Corp DBA · Paso Robles, CAN39BEAberdeen Flying Service · Aberdeen, SDN4137CN4137c Inc · Redwood City, CAN4429ETwo Niner LLC · Portola Valley, CA
Back to Cessna T210N