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 ('2072734')
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 ('2072734')
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.
N756GYLake Superior College · Duluth, MNN756JRWings Of Anglers LLC · Biloxi, MSN756JVRufus Briar Inc · Willow Spring, NCN756KZEight Two Tango Inc · Winchester, VAN756LRWingover Aviation Inc · Huntsville, ALN756MHKlingel Jeffery S · Byron Center, MIN756MNMoody Bible Institute Of Chicago · Spokane, WAN756PBQas Mile High LLC · Los Gatos, CAN756PPB&D Aviation LLC · Bowling Green, KYN756QKMiller Charles R · Montgomery, TXN756QXMayfield Kyle Barnes · Ukiah, CAN756RASan Diego Skylane LLC · San Diego, CAN756RFSky Kastle LLC · Milford, OHN756TKG & M Aircraft Inc · Wheat Ridge, CON756TRSawyer Charles W · Marstons Mills, MAN756VHCondair Flyers Inc · Latham, NYN756WAVeil Keith A · Jamestown, NDN756WBTechnav LLC · Columbus, INN756XWMid-America Communications Inc · Pocahontas, IAN756YMCrane Charles · Muskogee, OKN756ZLPerformance Aircraft Sales Inc · Lincoln, NEN756ZNMills James P · Chadds Ford, PAN756ZYChapa Jana K · Corpus Christi, TXN7570YJackson Rex A · Granbury, TXN7571TKillebrew Elizabeth Morrigan · Round Rock, TXN7571WCox Kevin D · Draper, SDN7578TPhysics Aviation LLC · Jonesboro, ARN757BGWallace Wayne W · Bristol, CTN757BPCommins Alfred D · Friday Harbor, WAN757DCLeon Hinkle LLC · Fort Ashby, WVN757DGHall Wesley W Trustee · Reno, NVN757GTGolf Tango LLC · Lubbock, TXN757HSRindlisbaker Chad · Pocatello, IDN757JWTary John G · Redondo Beach, CAN757PUAvs Aviation LLC · Williamsburg, VAN757RSRegistered aircraftN757VYRice Timyn J · Saint Petersburg, FLN757XUHighflight Inc · Perkinsville, VTN757YGDayton Pilots Club Inc · Springboro, OHN7580TBushgoair LLC · Chicago, ILN7583WJoseph Kenneth W DBA · Canton, OHN7584YMaher Andrew · Woodinville, WAN7586XDpair LLC · Rome, GAN7586YJaskoski Leo D · Avondale, AZN7592YClover Park Technical College · Lakewood, WAN7597XPlain Company Ltd · Bloomfield Hills, MIN7603XHanson Scott E · Auburn, CAN7607WZero Seven Whiskey LLC · Dewey, OKN7610XShezifi Mathew · Livermore, CAN767WDLibby William J · Hooksett, NH
Back to Cessna R182