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.
N231DBAntico Tile Imports Inc · Las Vegas, NVN231DCM2ok LLC · Minot, NDN231DDHoban Daniel J · Carson City, NVN231DFMusa Adam Dominic Raif · Austin, TXN231DH2 0 Kilo LLC · Colorado Springs, CON231DJPeterson Torrey L · Ennis, TXN231DRMonroe James C Jr · Winston Salem, NCN231DTVolkov Alexei · Mountain View, CAN231DVLansinger Edward J · Seattle, WAN231DWGlickson Alan S · Atlanta, GAN231DXJobs Kenneth R · Tucson, AZN231DYEnsser Kirby · Pine, CON231EEEggertsson Soley M · Las Vegas, NVN231EFStubbs J Phillip · Richmond, VAN231EGInternational Air Services Inc Trustee · Carson City, NVN231EKAkhtar M Jamil · Tempe, AZN231ELLaster Robert L · Clarksville, ARN231ERMooney Hunters LLC · Seattle, WAN231EUTomlinson Aviation LLC · Helena, MTN231EVSquires David B Trustee · Port Angeles, WAN231EWMooney Rats LLC · Cave Creek, AZN231EXPatete Douglas · Cedar Park, TXN231FADan Aviation Services LLC · Miami, FLN231FDZapref James L · Lakewood, WAN231FEBarta Gary S · Duarte, CAN231FFAlsman Nicholas · Leavenworth, KSN231FGMastrola Nancy · Painter, VAN231FKWesterhold Wayne · Cary, NCN231FTMosby Steve M Trustee · Lewistown, MTN231FWVan Frank Steven · Jean, NVN231FZStrange Jim · Tyler, TXN231GRj Air LLC · Irwin, PAN231GARegistered aircraftN231GCRegistration Pending · Homestead, FLRegistration pendingN231GGEllis Aviation LLC · Tuscaloosa, ALN231GHEager Mark A · Cameron Park, CAN231GLHunter Gary A · Fort Wayne, INN231GMMitchell Eric R · Chocowinity, NCN231GRGlahn Tyler R W · Surprise, AZN231GVRourk David · Cohasset, MNN231GZSkelly Inc · Farmers Branch, TXN231HAPc Aviation LLC · Kanarraville, UTN231HBRasch Robert W · Memphis, TNN231HCGifford Brian L · Millville, NJN231HESinger Peter S · Carver, MAN231HFBoie Kevin W · Vancouver, WAN231HGRegistered aircraftN231HHValiair Lc Trustee · Casper, WYN231HLShavlik John · Lavista, NEN231HNFisher Aviation Inc · Bulverde, TX
Back to Mooney M20K