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 ('5870212')
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 ('5870212')
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.
N6052QCash Alan B · Fort Worth, TXN6057QKennedy Kyle R · Berrien Springs, MIN6061QThurston David H · Cincinnati, OHN6063QTaylor Alan M · Nekoosa, WIN6066QArmagost James C · Belton, TXN6067QFrantz Joseph M · Gill, CON6068QPressley Jerry · Morristown, TNN6071QHaven Hospitatlity LLC · San Marino, CAN6072QTorres Mendoza Gonzalo · Rancho Cucamonga, CAN6082QIrvine Brooklyn L · Sacramento, CAN6083QAjirogi Michael T · Pearl City, HIN6087QTyson Michael A · Cupertino, CAN6088QParker Justan · New Durham, NHN6091QBridges Jeffrey Kemp · Cumming, GAN610MTMooney Flyers Inc · Sault Sainte Marie, MIN625MTMohs Joseph · Columbus, INN6294VColomello Charles P · Tillson, NYN63ABAircraft Leasing & Management LLC · Lewes, DEN63PKRegistered aircraftN63RMclenaghan Alvin N · Phoenix, AZN65ECMartinez Fernando · Midland, TXN65GLDavidson Amber M · Cocoa, FLN65NURanard Douglas R · Dugger, INN6619ULucas Jolie Candace · Pismo Beach, CAN6669UNix William C · Sterling, CON6680RWestlake Mark A · Jewett, OHN6684RRoberts Alec · Boulder, CON6686RAnderson Benjamin P · Bellevue, NEN6688RFarley Clayton · Hanford, CAN6691RSgt Land And Cattle Co LLC · Bennington, KSN6694RRegistered aircraftN6695RKepner Charles M · Shepherd, MIN6697RJ Bar Ranch LLC · Downey, IDN671DBThomas Andreas P · Bend, ORN6751VManley William T Jr · Lakeside, TXN6753VDegraffenreid Donald R · Fort Mohave, AZN6764NBiermann William W · Hollister, CAN6780VLimpert Theodore H · Syracuse, NYN6838VMaldonado Abel Jr · Santa Maria, CAN6840VVa'Llancourt Marco · Newport, VTN6842VKoontz Stephen W · Benton, KSN6845UTarrant James D · Wenatchee, WAN68BWRegistered aircraftN68JJRegistration Pending · N Richlnd Hls, TXRegistration pendingN6902SPaul David G · Hotsprings Village, ARN6922UStrategic Aviation Assets LLC · Havre, MTN6924USchleisman Terry J · St George, UTN6925UDurocher Michael G · New Hudson, MIN6926UCreed Stephen R · Fort Worth, TXN6927UJones Robert Y · Alba, TX
Back to Mooney M20E