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 ('2073402')
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 ('2073402')
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.
N76RRReynolds Joseph I · Irving, NYN7743GVaughn Investment Services LLC · New Plymouth, IDN777JKGeoterra Inc · Eugene, ORN87MSCrist Lawrence E · Marietta, GAN9407TBodin Logan T · Lake Charles, LAN9409TBas Part Sales LLC · Greeley, CON9419TPieper Mike D · Chandler, OKN9422TGraves Frank C · Nocona, TXN9424TGill Melvin L Jr · Nashville, TNN9425TBlue Skies Flying Services LLC · Blandon, PAN9430TRmb Leasing Inc · Dover, DEN9433TDoyle Victoria L · Salem, ORN9434TChurch Philip M · Statesville, NCN9438TBray Max W Jr · Dora, ALN943AHHaley Keith · Tonawanda, NYN9441TDevil Dusters Inc · Artesia, NMN9445THale Tom · Browns Valley, CAN9453THansen Jerry E · San Antonio, TXN9458TWasp Air LLC · Hamilton, MTN9463TMcbee Kenneth H · Pasadena, TXN9464THansen Peter J · Collierville, TNN9468TBas Part Sales LLC · Greeley, CON9472TWilliams Chad R · Jamestown, INN9474TWalker James O · Lovell, WYN9476TRegistered aircraftSale reportedN9478T4cl Inc · Wilmington, DEN9489TRegistered aircraftRegistration pendingN9493TCorwin Bert C · Rapid City, SDN9494LRegistration Pending · French Village, MORegistration pendingN9496THudson Willis C · Hendersonville, NCN9501TNeverland Air Co LLC · Myerstown, PAN9502TSilveria Michael J · Soledad, CAN9509TKline John C · Wolcottville, INN9517TSteele Cody T · Polson, MTN9518TParks Paul E · Titusville, FLN9527TTechnical Education Services Inc · Virginia Beach, VAN9529TGarcia Richard E · Atwater, CAN9530TNewby Harold A · Ramona, CAN9533TWarren Roderick D · Hiawatha, KSN9534TSale Reported · Spring, TXSale reportedN9535TGelner Ronald L · Pearland, TXN9537TSky West Aviation Inc Trustee · Albuquerque, NMN9540TChino Aviation Inc · Chino, CAN9541TNevill John D · Tahoka, TXN9542TLarsen Richard A · Wannaska, MNN9546TAerographics Inc · St Cloud, MNN9558TWatson Stephen C · Flemingsburg, KYN9560TStern Harvey W · Middletown, NYN9562THiggs Jared E · New Boston, TXN9564TAlvarado Ruben Jr · Brownsville, TX
Back to Cessna 210