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.
N231HRVictor Victor LLC · Waynesville, NCN231HVRomeike Hannah · Talbott, TNN231HYRab Aviation LLC · Hockley, TXN231HZDannewitz Brian D · Newnan, GAN231JCrawford Joseph Victor · Wilsonville, ORN231JCWingfield Jeffrey · San Antonio, TXN231JEThenault Georges · New Smyrna, FLFirst renewal noticeN231JGNelson Scott T · Amarillo, TXN231JLBongiorni Robert W Jr · Burgettstown, PAN231JNCaptain Chucks Aerial Adventures LLC · Kalispell, MTN231JSPutsche Harvey G · Georgetown, TXN231JTAradhyula Praveen · Ballwin, MON231JVReimann Martin Christian · Tucson, AZN231JWKnapp Richard · Seale, ALN231JYEtak Aviation LLC · Inverness, FLN231KCAlexander John V · Mesa, AZN231KDClub 231 Inc · Palo Alto, CAN231KEMbsp Enterprises Inc · Wilmington, DEN231KGRegistered aircraftN231KHGressman Donald R · Alamogordo, NMN231KJSoykan Orhan · Lino Lakes, MNN231KLMurphy Thomas Joseph · Southport, NCN231KMBailey Bryan · Liberty, UTN231KPGoodwin Matthew J · North Branford, CTN231KQMcdermott Thomas · Huntsville, ALFirst renewal noticeN231KVShort Final LLC · Grants Pass, ORFirst renewal noticeN231KWSchrobilgen Christopher M II · Gig Harbor, WAN231KXQualitair LLC Trustee · MichelstadtN231KYMorris Kevin William · Camden, SCN231LFranckowiak Bernard A · Nokomis, FLN231LATrexler Gary A · Abingdon, VAN231LEIntegrated Realty Group Inc · Laguna Hills, CAN231LFLong James Robert Leslie · Reno, NVN231LGTerpening Brian E · Roanoke Rapids, NCN231LMAsianov Alexander · Saint Johns, FLN231LPTaylor Leslie G Trustee · Cody, WYN231LRMowbray-Parker Nicoya Jade · Flower Mound, TXN231LTWhitfield Michael Lee · Leander, TXN231LULewis Matthew G · Wilmington, MAN231LVFalcon Global LLC · Sedona, AZN231LWNewberg Edgar T · Hector, MNN231LXGlueck Robert Gary · Astor, FLN231MMitchell Philip A · Rhome, TXN231MEBass Daniel · Winona, MNN231MFCoker Steve L · Tyler, TXN231MGRichard F Marshall Inc · Fort Jones, CAN231MHPacific Commonwealth Mortgage Co · Incline Village, NVN231MJOchabauer August · Burlingame, CAN231MKEastman Gregory L · Pueblo, CON231MLL8n Aero LLC · New Harmony, UT
Back to Mooney M20K