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.
N5748NShepard Scott D · Sanger, TXN5756VReneau Steven R · Houston, TXN5762HWeathers Scott M · Fort Worth, TXN57638Crabdree Marty D · Conroe, TXN57639Fox Larry D · Hinton, WVN5764SAlianza Development Inc · Mammoth Lakes, CAN5766MWiechert Ronald J · Tipton, IAN5767TRaveney Thomas W · Granger, TXN5769QHrj Leasing LLC · Angier, NCN5773SPlane Partners LLC · Carlton, WAN57785Shapnek Lawrence R · Cedar Crest, NMN5779RLangar Paul D · Golden, CON5781XHurley Christopher D · Anderson, SCN57823Sg Aircraft Inc · Bethlehem, PAN5787CRustad Mark · Roseglen, NDN5789MRamos Mario · Asheville, NCN57MLMcgee Joseph · Newport Beach, CAN58064Zero Six Four LLC · Carbondale, CON5806QLocke Charles T III · Darien, CTN5807VWhite Yvonne S · Lanham, MDN5807WZamora Cueva Jose Ruben · Boerne, TXN58089Hill Neal A · Jersey City, NJN5808BRobinson Bevan LLC · Colorado Springs, CON5808FGf Air LLC · Las Vegas, NVN5808TSalt Warren G · Colorado Springs, CON5808XDippolito Michael Mario · King Of Prussia, PAN58093Plane Fun Inc Tr Trustee · Snellville, GAN5809BDow Noel C · Arlington, TXN58104Eddj Aviation LLC · Melfa, VAN5810DCamber One LLC · Tempe, AZN5810GDow Fred L · Friant, CAN5810JClub 5280 Aviation LLC · Crowley, TXN5810QCarriker Nathan · Granbury, TXN5810RKenmare Aviation LLC · Kenmare, NDN5810TNel Pieter W · New York, NYN5810ZMountain West Aviation LLC · Gig Harbor, WAN624GWJawz Management LLC · Chandler, AZN645BKBk Earnest LLC · Oviedo, FLN654JBNumber Six Aviation LLC · Nashua, NHN668MKAlta Wings LLC · Longmont, CON66JGBas Part Sales LLC · Greeley, CON66RJShapiro Mathew J · Clarkrange, TNN683AAPlane Fun Inc Tr Trustee · Snellville, GAN6969RFurf Air Inc · Wilmington, DEN697SPGregersen David E · Oakland, CAN698AEWolff Martin · Houston, TXN6LLKasakoff Lloyd · Diamond Bar, CAN700XDReed John L Jr · Ormond Beach, FLN7066VMooney Spirit Flying Club LLC · Ballwin, MON706GP3 Brothers Concepts LLC · Commerce City, CO
Back to Mooney M20K