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.
N6775NAirvantage Global LLC · Lake Worth, FLN6776UParmer Jeffrey C · Redondo Beach, CAN6777NStephens Mark A · Las Vegas, NVN6777ULongmont Mooney · Longmont, CORevoked, canceledN6778ULift Air Services LLC · Woodland Hills, CAN677KSassinsky Jeffrey B · Haddonfield, NJN6780NMegee Michael J · Fort Mohave, AZN6781NThornton Brad · Decatur, TXN6782VRose Gary E · Mendocino, CAN6783NBaker Dennis M · Temple Terrace, FLN6784NGrundmann William B · Bradenton, FLN6784UMellen Roger B · Winston, ORN6784VN6784v LLC · Casper, WYN6787NN6787n LLC · Hanover, NHN6789NOwnbey James L · Lubbock, TXN6792NWhite Rock Advisors · Wenham, MAN6792VSchmidt Jason A · Wasilla, AKN6795NStief Todd F · Mount Pleasant, SCN6795VTaub John F · Sarasota, FLN6797UHeidenreich Peter · Monroe, GAN6798UAzevedo Robert S · Socorro, NMN6799URegistered aircraftN679MMcquack Aviation LLC · Belding, MIN6801NHines Benjamin D · Sulphur Springs, TXN6801ULavere Paul H · Adams, NYN6802UKlingenberg Timothy C · Udall, KSN6803ULau Tim · Tustin, CAN6805NHuderle Todd M · Grafton, NDN6809UVan Wormer Willard D · Leavenworth, KSN6811NVan Koetsveld Ernst J · Alexandria, VAN6811UColeman Ronald R · Walla Walla, WAN6812UAll Things Guns LLC · Westfield, WIN6812VMoita Robert Jimizez Jr · Templeton, CAN6813UShelton Timothy · Salisbury, NCN6814NMckenna Terence M · Scotts Valley, CAN6814UGeorgescu Radu A · Louisville, KYN6816NHollis Leo D Jr · Bluffdale, UTN6816UDo Cong · York, PAN6818UBaltz Mark W · Horseshoe Bend, ARN6819NLuxum Studios LLC · Cumming, GAN6821URed Baron LLC · Middletown, DEN6822NBianchi Marion A · Goose Creek, SCN6825NWilliams Jerry Riley Sr · Wabbaseka, ARN6828NFisher Scott · Searcy, ARN6830NPierce Michael J · Kerrville, TXN6831VMirage Partners LLC · Biddle, MTN6832ULanetti Leonard J · Malvern, PAN6832VCrawford Sharri R · Rio Rancho, NMN6834NSiebold David J · Painesville, OHN6834UFlydog Aviation LLC · East Grand Forks, MN
Back to Mooney M20C