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.
N231RJIndependence Enterprises LLC · Granby, CON231RPTaylor William W Jr · Weatherford, TXN231RQLay Lawrence W · Douglass, KSN231RSRoth Carl R · Marshall, TXN231RTLevinson Ben · Decorah, IAN231RU42nd Design LLC · Kirkland, WAN231RXStratte Joseph J · Yakima, WAFirst renewal noticeN231SBDean William Roger · Webster Springs, WVN231SDGulbis Edgars · Laguna Niguel, CAN231SESierra Echo Aviation LLC · Kalispell, MTN231SFFowler George · Sarasota, FLN231SJBrennan John P Jr · South Easton, MAN231SMWiller Jim · Erie, CON231SQN231sq LLC · Tulsa, OKN231SRHaag David S · Littleton, CON231SSHamill John L · Arbuckle, CAN231STCase Donna K · Granbury, TXN231TBEtx Aircraft LLC · Windsor, CON231TCBrothers Michael N · Metaire, LAN231TFAerospatial Systems LLC · Boulder, COFirst renewal noticeN231THMoe Robert P Trustee · Clovis, CAN231TLCapital Auto Sales · Hickman, NEN231TTKf Aircraft LLC · Murfreesboro, TNN231TWSkaug Scott Jon · Aberdeen, NCN231TXFrahm Steven Robert · Havre, MTN231UBosia Acres LLC · White City, ORN231VLaurmark Inc · Palmdale, CAN231VAS & A Tek LLC · Midway, UTN231VFKmp LLC · Peoria, AZN231WBJurkiewicz Norbert R · Austin, TXN231WGSky West Aviation Inc Trustee · Albuquerque, NMN231WHJaybird LLC · Goodyear, AZN231WLObar Daniel C · Middleton, IDN231WWBaeronautics LLC · Solon, OHN232TTHinds Robert S Jr · Birmingham, ALN233JBN233jb LLC · Bethesda, MDN234JPBistline Worth · New Harmony, UTN235DRJones Mark A · Litchfield Park, AZN23FLQualitair LLC Trustee · MichelstadtN241HPWest Palm Breathe Free And Wellness LLC · West Palm Beach, FLN242BBN242bb Inc · Fort Lauderdale, FLN2500MHenderson Craig B Trustee · Van Buren, ARN251BWVarsolona Frank L · Las Vegas, NVN252AStallings Aircraft Propeller LLC · Wynne, ARN252ACStewart Brent E · Oro Valley, AZN252ADNeret Michael George · Sugar Land, TXN252AHStordahl Ronald A · Thief River Falls, MNN252AJPhainopepla LLC · Tucson, AZN252ANVan Waardhuizen Jonathon B · Sarasota, FLN252APBraun Eric Trustee · Anthem, AZ
Back to Mooney M20K