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.
N252ARSkousen Joel · Spring City, UTN252ASN252as LLC · Hillsboro, ORN252AVKortopates Paul T · San Diego, CAN252AYMartinkewiz Gregory · Argyle, TXN252AZShellhouse Robert Gregory · Dayton, OHN252BWoods Brian S · Longview, TXN252BACoastal Orthopedic Associates LLC · Holmdel, NJN252BDLachman Aaron · The Woodlands, TXN252BHHorst Commercial Ventures LLC · Sanger, TXN252BMJeffrey Friday · Carbondale, CON252BNGibisch Glenn J · Naples, FLN252BRMann John · Coopersburg, PAN252BSAlta Aviation LLC · Broomfield, CON252BYLance Christopher D · Vacaville, CAN252BZJml Ventures LLC · Luverne, ALN252CAHuckabay John A · Coeur D Alene, IDN252CCLetsgobrandon.Com LLC · Pine Bush, NYN252CFBowman Douglas G Trustee · Santa Rosa, CAN252CGPlane Fun Inc Tr Trustee · Snellville, GAN252CNMcmanus Thomas M · Ridgefield, CTN252CRMcvay Thomas T · Minneapolis, MNN252D252 Delta Inc · Atlanta, GAN252DBValiair Lc Trustee · Casper, WYN252DCEhrick Richard T · Steamboat Springs, CON252DKKristoferson David J · Georgetown, TXN252DRGoudeau Lyle A · Scottsdale, AZN252DSSturgill Duell L · Staffordsville, KYN252EXiaowei Shi · Las Vegas, NVN252EMMaidens Donald S · Novi, MIN252FBKramer Vernon F · Eagle River, WIN252FMHawk Unlimited LLC · Kalispell, MTN252GBRedrockbluewater LLC · Moab, UTN252HMLeeds Stained Glass Co Inc · Leeds, ALN252HWBeverly Robert E · Lewis Center, OHN252JCRc Skywagon LLC · Miami, FLN252JEEdlund Richard J · Lenexa, KSN252JHStratton William A · Denton, TXN252JPInternational Air Services Inc Trustee · Carson City, NVN252KMRegistered aircraftN252LRigoulot James Paul · Fort Mill, SCN252MDouglass Alloys LLC · Zanesville, OHN252MBN252mb LLC · Lexington, KYN252MCSwan And Associates Inc · Brockton, MAN252MEBadger Jerry D · Terre Haute, INN252MKMurphy Thomas P · Camp Hill, PAN252MLTaykota Planes LLC · Mandan, NDN252MRRudolf Jonathan B · Farmington, NMN252MSWilson James A · Manitowoc, WIN252MXMcginney Franklin S · Junction, TXN252MZGrant Sean · Placentia, CA
Back to Mooney M20K