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 ('2072730')
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 ('2072730')
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.
N92265Futchagribusiness LLC · Broxton, GAN9226GLefevre Jonathan W · Haskell, TXN92277Whiskey Bravo Investments LLC · Bulverde, TXN92280Look To The Sky LLC · Middletown, DEN92281Jera Aviation LLC · Brooksville, FLN92282Registered aircraftN92286Wpr Group LLC · Clinton, MSN9228GDouthitt Kevin S · Long Bch Twp, NJN92291Media Stew LLC · Carson City, NVN92298Ponderosa Aviation LLC · Safford, AZN92299Barxbar Aviation LLC · Mesa, AZN9229GKhademi Amin · Chino Hills, CAN92311Delorenzo Thomas H · Nazareth, PAN92316Caldwell Kevin M · Camano Island, WAN9231GJock Carl · Roscommon, MIN92323Tarandi Leasing Inc · Oswego, NYN92329Gorski Stephen · Sarasota, FLN92331Global Business Concept LLC · Newton, MAN92335Steinle Michael · Lake Village, INN92336Chiatovich Larry R · Grandview, WAN9233GSchaffitzel Mark · Owasso, OKN92340Jerrett Lamont · Chino Hills, CAN92341Registration Pending · Wanchese, NCRegistration pendingN92344Mastley William T · Reno, NVN92346305 Sky LLC · Boca Raton, FLN9234GGodlevsky Leslie · Hot Springs, SDN9235189th Marin Aerosquadron Inc · San Francisco, CAN92353Silver Wings Flying Club · Los Gatos, CAN92359Schmick Kenneth R · Fond Du Lac, WIN92386Lee Eric H · San Diego, CAN9238GSprang Pamela G · Newnan, GAN92399Hyland Flyers Inc · Coon Rapids, MNN92405Burgess Brian Keith · Arnoldsville, GAN92406Anderson George C · Centerville, UTN92415Registered aircraftN92416Fly Guys LLC · Olympia, WAFirst renewal noticeN92419N92419 LLC · Manteo, NCN92422Mack Nester R · Utopia, TXN92428Woodall Richard J · Yakima, WAN9242GJones Reginald L · Baton Rouge, LAN92433Vandervis Inc · Tulare, CAN9244GTrover Nicholas · Chico, CAN92452Meredith Judyann Cote · Lexington, KYN92456Watt Robert B · Mount Vernon, ORN92458Selby James T · Valley Center, CAN92459Warren Ronald Mark · Elizabeth City, NCN9245GHerb Liverett Companies Inc · Rio Linda, CAN92460Wings 182 LLC · Genoa, NVN92461Flying Six Inc · Lander, WYN92463Sopatyk Brian D · Boise, ID
Back to Cessna 182N