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 ('5870220')
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 ('5870220')
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.
N3991HCuyle John K · Redmond, WAN3997HChristopherson Rodney V · Williamsburg, MIN4006HMcnorton Robert L · Cantonment, FLN402LADm-Tech Inc · Corning, CAN4030HChristensen Michael David · Sleepy Eye, MNN4032HValenti David A · Salt Lake City, UTN4035HSmitr LLC · Mooresville, NCN4037HWatson Marshall · Sublette, KSN4041HInternational Air Services Inc Trustee · Carson City, NVN4060HDue North Productions Inc · Santa Monica, CAN4063HBovenzi Mark A · Rancho Santa Fe, CAN4087HHarmonic Air LLC · Portland, ORN408LABeach Bound Flyers LLC · Mountain Brk, ALN4093HWilliams Charles · Wolfeboro, NHN4094HRichardson Scott A · Kalispell, MTN4097H1234g LLC · Topeka, KSN4098HLance Aero Inc · Mechanicsburg, PAN40APCaelus Air LLC · Sheridan, WYN40CCUp And Away LLC · Seymour, TNN40FMKiessling Jay J · Erie, PAN413ZMEncore Aviation LLC · Terre Haute, INN414MSJwk Air LLC · Pauline, SCN41EJDutta Sandeep · Foster City, CAN431BTTrout Robert J · Brownsburg, INN43PGBender Brian C · Los Angeles, CAN43WTSummit Aviation LLC · Dover, NHN444TKFahl James E · Sparks, NVN44CGBlackwolfden Aviation LLC · Belgrade, MTN4514HIndigo Of South Fl Inc · Sunrise, FLN4571CBlair Whitney · Temecula, CAN4710HHamilton James R · Colorado Springs, CON4783HAckerman David M · Prospect, KYN479CCRood Donald F · San Diego, CAN47BEWestgard Richard W · Golden, CON47KPInternational Air Services Inc Trustee · Carson City, NVN47RJBzm LLC · Incline Village, NVN4832VGiovanni Greco · Centennial, CON4SRRhyne Timothy Neil Sr · Enterprise, ALN500BAero Fliers Inc · Akron, OHN500NSMulligan James · New York, NYN50FMHeywood Charles E · Ridgway, CON513SBBelisle Barry A · Lancaster, TXN521AGRegistered aircraftN52202Li Tao · Rancho Cordova, CAN5223JNelson Samuel O · Middletown, OHN5230YSky West Aviation Inc Trustee · Albuquerque, NMN5238VNo 3 Sea Air Land Inc · Pensacola, FLN5252GMaxepr LLC · Reno, NVN5252UWhite Wings Ltd · Wilmington, DEN5253GRegistered aircraft
Back to Mooney M20K