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.
N305RTMorris Alysse · Rapid City, SDN305SESouthern Aircraft Consultancy Inc Trustee · Casper, WYN305TBExecutive Aeronautical Group LLC · Pensacola, FLN305TJSenninger Thomas P · Clermont, FLN3089UCharles T Crinnian Md Pc · Phoenix, AZN308MARegistered aircraftN310FWWyslup Natascha Bristi · FrankfurtammainN311FWAmdel Holding LLC · Houston, TXN311MAWilkins Ralph Steven · Guymon, OKN311PCBonacci Thomas M · Salt Lake City, UTN314EBRegistration Pending · Las Vegas, NVRegistration pendingN31GHHause James Howard · Negley, OHN321QCAden Michael L · Maryville, ILN321RKGaston Charles · Stephens, ARN321RMBigler & Associates Aviation Inc · Cameron Park, CAN322DBPoint To Point LLC · Wadsworth, OHN322DDPlane Fun Inc Tr Trustee · Snellville, GAN329JSHc Rec LLC · Georgetown, KYN32CEMiller David J · Naperville, ILN32DGRous LLC · Fredericksburg, VAN337HSCatering Of Central Texas Inc · Kerrville, TXN337PPStreeter Adam W · Grand Prairie, TXN338DDAltered Dimensions LLC · Noblesville, INN33RKRedcell Air Inc · Miami, FLN33TZ25-0389 Inc Trustee · Wilmington, DEN33XLEric S Osburn · Mesquite, TXN341PMFreil Lawerance E III · Woodstock, GAN34MPValiair Limited Co Trustee · Casper, WYN3556HRocket Joy LLC · Aurora, CON3558HPearce Terrace Edwin · Theodosia, MON3594HKilo Sierra LLC · Harwich, MAN3636HLasar Inc · Lakeport, CAN3650HRoyal Horus Elevate LLC · San Antonio, TXN3653HDove Kenneth F · Danville, CAN3654HThompson William D · Godley, TXN3661HHamer Robert E · Beaumont, TXN3663HGould Ryan · Girdwood, AKN3671HErickson Orchards Inc · Ritzville, WAN3699HBarnhardt Jerry · Stockton, CAN369BYVito Air Inc · Wilmington, DEN36PEMason Robert · Fayetteville, NCN3777Wings Of Eagles · Myrtle Beach, SCN381SPLunseth John B II · Long Lake, MNN387WBMckenzie Jan · Fort Collins, CON389CSSahi Carl R · Coventry, CTN3901HKeggereis Tom · Stockton, MON3903HMinniti Robert J III · Lansdowne, VAFirst renewal noticeN39252Wildgen Harry J · Ashland, ORN3928HRegistration Pending · Redlands, CARegistration pendingN398JFBrown Garry M · Riverside, CA
Back to Mooney M20K