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.
N231MMPitts Arnold · Elizabethtown, NCN231MNMacair LLC · Santa Barbara, CAN231MPCraig Steven A · Olympia, WAN231MSKimmerly Andrew · Chandler, AZN231MTBell Kenneth M · Cedar Park, TXN231MUStorey Otto John · Lake Oswego, ORN231MVSouthern Aircraft Consultancy Inc Trustee · Casper, WYN231MYCastle Compu Systems LLC · New Castle, PAN231NABrien Lucas M · Norwich, VTN231NCCross Joshua A · San Antonio, TXN231NDPowers Jimmy Lee · San Antonio, TXN231NET & M Enterprises Inc · Wilmington, DEN231NFAratreus Holdings LLC · South Charleston, WVN231NHBooska Steven A · Angwin, CAN231NJQuinton Aaron S · Columbus, INN231NLBurkhart Scott C · Livermore, CAN231NNKelly Luciano LLC · Independence, OHN231NPStiritz Thomas A · Spokane Valley, WAN231NSLawrence Steven R · Chowchilla, CAN231NUMcmillan Keith A · Milwaukee, WIN231NZSchumacher Kim L · Beach City, OHN231PWilverding Jerome C · Stockton, CAN231PBSnapp Steven J · Los Alamos, NMN231PDDuncan William Thomas Jr · Virginia Beach, VAN231PEHiawatha Valley Aviation Inc · Hawley, MNN231PFStephans Emery J · Waitsfield, VTN231PGHartford Aircraft LLC · Monument, CON231PLBryan Shawn D · Kempner, TXN231PNTaylor Richard · Pacific Palisades, CAN231PPBlackdog Air LLC · Seattle, WAN231PQHutchens David · Pikeville, KYN231PRHoegg Thomas K · Mountain Home, IDN231PSVero Flyboys LLC · Vero Beach, FLN231PXLeading Edge Aviators LLC · Denver, CON231PZTurner Robert A Jr · Elmhurst, ILN231QBBeamalloy Inc · Houston, TXN231QECarter David A · Charlotte, MEN231QGD4 Enterprises LLC · Longview, TXFirst renewal noticeN231QHWalworth County Holdings LLC · Lake Geneva, WIN231QJLecl Air Corp Trustee · Wilmington, DEN231QMMcwilliams Peter S · Spokane, WAN231QPRaney Chad T Trustee · San Antonio, TXN231QTDenton Lake Ltd · Port Charlotte, FLN231QYElrod Delynn R · Portland, ORN231QZAlexander Michael · Brentwood, TNN231RBDemotechnics LLC · Deerfield Beach, FLN231RCKc Initiative LLC · Canyon, TXN231RDLewis Shelly D · Keller, TXN231REStern David B · Burdett, NYN231RFPaige Steven · Bogalusa, LA
Back to Mooney M20K