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 ('5870225')
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 ('5870225')
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.
N31007M&E Air LLC · San Marcos, TXN311PDHaehnle Michael J · Milford, OHN312DKline Robert H · Oley, PAN321ELBecker Ronald G · Cresson, TXN321MDBrown Melvin W Jr Trustee · Shady Shores, TXN322PMMsr Aviation LLC · San Diego, CAN322RWKraemer Jeremy A · Melrose, MNN323DMWard Frank J · N Richland Hills, TXN326TJBarnett John M · Fredericksburg, TXN332LCockerell William C Trustee · Zephyr Cove, NVN333YCSky West Aviation Inc Trustee · Albuquerque, NMN334FLChampionx LLC · Sugar Land, TXN33GXSiman-Tov Yariv · Redmond, WAN341JSTibbs Jeffrey M · Lakewood Ranch, FLN341PSWestern States Air LLC · Phoenix, AZN345DTPlane Fun Inc Tr Trustee · Snellville, GAN345TFWilkinson Mark A · Lincoln, MAN345USAvion Solutions Group LLC · Apex, NCN349BPLundeen Matthew L · Tigard, ORN34DBRegistered aircraftN3535RMannion Paul R · Mentor, OHN357AFour Leaf Air LLC · Cedar, MIN359PSMoondancer LLC · Vacaville, CAN35FCTransonic Inc · Auburn, CAN35MDGarbalosa Ryan · Myrtle Beach, SCN368CMKraemer Jeffrey J · Cold Spring, MNN37MGWood Ronald G · Weatherford, TXN380MMFolk Daniel H · Urbana, ILN381LMorgan Fred M · Onancock, VAN393PSVein C Jason · Riviera Beach, FLN395MRParamount Risk Mgmt And Insurance Scvs LLC · San Luis Obispo, CAN39HWApple & Vine Aviation Services LLC · Reidsville, GAN401PSLesmeister Dean · Kindred, NDN404WMArmbruster LLC · Amherst, OHN409PCSmith Lowry Carl Trustee · Leedey, OKN40CFG&M Flyers LLC · Wilmington, DEN410MBHall Donny K · Cookeville, TNN411TXGilbert Ivory M · Bonita Springs, FLN413EM413em LLC · Columbia, ILN416USClepper Francis D Jr · Bennington, NEN41HTJacobs Gregory R · Pinole, CAN422SSInternational Air Services Inc Trustee · Carson City, NVN426WULucy In The Sky LLC · Los Angeles, CAN429PSMjk Leasing LLC · San Antonio, TXN42MDN42md LLC · Ashburn, VAN42TVK2 Aviation LLC · Carroll, IAN430GDrew Gorrie Photography LLC · Lawrenceville, GAN430TDHhc Aviation LLC · Melbourne, FLN431DBDuininck Companies LLC · Prinsburg, MNN431GXHb Acquisitions LLC · North Miami, FL
Back to Mooney M20R