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 ('5870208')
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 ('5870208')
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.
N9291VHutchens David R · Pikeville, KYN9295VSt Denis Robert G · Lake City, FLN92AVFlachs Christopher R · Kalamazoo, MIN9301VHack Christopher J · Highland Lakes, NJN9311VRegistration Pending · Queen Creek, AZRegistration pendingN9315VGroff Joseph J · Colfax, CAN9316MSale Reported · Kalispell, MTSale reportedN9317VSpaghetti Aviation LLC · Derby, KSN9325VJaa Holdings LLC · Springfield, ILN9331VMartin Edward J · Poplar Grove, ILN9339VTechnical Education Services Inc · Virginia Beach, VAN9341VAvalle Oscar A · Chicago, ILN9343VFundora Joel A · Altamonte Springs, FLN9345VBroussard Troy A · Dickinson, TXN9350VSprunk Stephen · Anderson, OHN9353VLangholz Denise M · Covington, WAN9357VWise Christopher J · Plano, TXN9358VEickman Jaret · Scottsdale, AZN9360VHarvey John S · Garland, TXN9361VDanson Corp · Henderson, NVN9371VFly Me To The Mooney LLC · Owings Mills, MDN9373VEl-Cheikh Taimour · Waldorf, MDN9375VDavis Wesley · Dayton, OHN9382VWesterhold Wayne E · Cary, NCN9386VSwaney Matthew P · Thomasville, NCN9389VAllen Jeffrey W · Crestwood, KYN9391VPizer Ronald J · Incline Village, NVN9393VStenger Jimmy Mh · Millington, MIN93CMekolichick Jerry D · Whitehall, PAN9406VKuyami Inc · Las Vegas, NVN9410VRlangone Inc · Seaford, NYN9414BAddison Edward T · Matamoras, PAN9415VViens Gerald J · Belchertown, MAN9417VFraembs David G · Canyon Lake, TXN9420VAerologic LLC · Yorktown, VAN9423VLevin Robert G · Roseburg, ORN9425VEcaviators LLC · Wilmington, DEN9429VFrankel Daniel A · Madison, OHN942TBBailey Thomas R · Benton, KYN9434VKnackstedt Dennis R · Winfield, KSN9438VPrestridge Jacob · Portland, ORN9442VFlight Operations Academy LLC · Prescott, AZN9449VClark Jeff W · Piedmont, MON9452VFriesen Dwayne Phillip · Overton, TXN9461VZembraski Jeffrey · Nocona, TXN9463VHatcher Mark F · Aloha, ORN9471VJ S Alguire Consulting Forestry Services Inc · Dover, DEN9474VCasa Patrick Greg · Albuquerque, NMN9477VMurnville Glenlove Flyers Ltd · Delaware, OHN9484VHannon Fredrick W · Punta Gorda, FL
Back to Mooney M20C