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.
N6409YChino Aviation Inc · Chino, CAN6410NAerial Services Inc · Cedar Falls, IAN6417NTaylor Michael Norman · Chino Hills, CAN6420YFlying Amigos Aviation LLC · Las Cruces, NMN6421YHulett Gregory · Las Vegas, NVN6431NMorton Craig Allister · Toluca Lake, CAN6439NSpectraq LLC · Las Vegas, NVN643UFRegistered aircraftN-number assigned (import), not yet registeredN6440YTamarack Graphics LLC · Salt Lake City, UTN6442YPouppeville LLC · Tulsa, OKN6443NEwers Richard G · Indio, CAN6445YRomero Bernard L · Santa Fe, NMN6447ACouch Andrew W · Newport Beach, CAN6450YAttica Flyers Inc · Lafayette, INN6453NUgly Johns Aircraft LLC · Afton, OKN6455CPruett Steven H · Midland, TXN6459CBallair LLC · Dalhart, TXN6466NHagan Joseph · Steward, ILN6469NKestrel Aviation LLC · La Center, WAN646CDRegistered aircraftN6470YSkyhigh Enterprises LLC · Holland, MIN6479NSouth Aero LLC · Albuquerque, NMN6479YGv Air Inc · Medford, ORN647SBHyde Matthew L · Santa Cruz, CAN6482YSky West Aviation Inc Trustee · Albuquerque, NMN6492YMiller Gary Lee · Pittsburgh, PAN6493NEagle Cap Leasing Inc · Enterprise, ORN6493YNeed To Fly LLC · Yukon, OKN6499NHelgren Quentin C · Oakland, CAN6505N3c3 Aviation Inc · Dania Beach, FLN6506GWestern Skyways Inc · Montrose, CON6517APeterson Holding Co · San Leandro, CAN6519ABreen Jerry P III · Center Point, TXN6529YBbd Lynch Family Lp · Houston, TXN6530YDelgado Gonzalez Hector · San Diego, CAN6532NN6532n LLC · Sioux Falls, SDN6535YRichardson Jane S · San Angelo, TXN6538NHaynie Ray G · Auburn, WAN6542CLeonard Summers · Pleasanton, CAN6544YSchwarzenberg Johannes · Helena, MTN6546NMitchell Matthew J · Penn Yan, NYN6547CJrp Management LLC · Williams, AZN6553YCenturion Aero LLC · Coos Bay, ORN6562YKp Builders Inc · Pittsburgh, PAN6567YMoeller Gerhard Walter · Goshen, OHN656MCMcintosh Justin W · Joshua, TXN6572YMoss G B · Bakersfield, CAN6584NHartmann Wayne E · Hill City, SDN6591NRickey James R · Hanford, CAFirst renewal noticeN6602CSnip Robert C · Telluride, CO
Back to Cessna T210N