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 ('8360608')
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 ('8360608')
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.
N64WMSeg Leasing LLC · Selinsgrove, PAN66CGPosada Raul Ignacion · El Paso, TXN680FPEisert Fred J · Yellow Springs, OHN683RLMach 10 Cap LLC · Fincastle, VAN696MEBgdr LLC · Wilmington, DEN69LGMills Montague S · Dallas, TXN700ABSale Reported · Lewes, DESale reported, pending cancellationN700BVN700bv LLC · Zeeland, MIN700MFEtavan LLC · Satellite Beach, FLN701KENorthern Jet Sales LLC · Port Saint Lucie, FLN701WMB&B Aerospace LLC · Rosamond, CAN70KCLa Chabola Aviation LLC · Plano, TXN711BYHamlin Richard · Wellington, KSN713HMPinto Carlos · Tucson, AZN721DCClark Steve L · Baytown, TXN74BMAlexander City Aviation Corp · Alexander City, ALN7550SDoctors Diet Inc · Nashville, TNN75RFJefferies Stanley J · Coos Bay, ORN765Moby Partnership · Albuquerque, NMN767TBOx Aviation LLC · Monmouth, ORN777MKPecori Emil R · Oakdale, PAN778EJobin Lyle · Saint Augustine, FLN78KTJbt Aviation LLC · Shawano, WIN800AAJasper Air LLC · Toms River, NJN800FYJohnson Kirk B · Severance, CON8012JAirms LLC · Wichita, KSFirst renewal noticeN8019JThomas Anna D · Kiana, AKN804LGDem Ventures LLC · Wichita, KSN826DSouthall Charles A Trustee · Naples, FLN831GWAspen Flight Operations LLC · Carbondale, CON86LGEast High Flying Inc · Othello, WAN88CXChamplin Aviation LLC · Kerens, TXN8AQMiller Donald W · Harrisonburg, VAN900AKNorthern Aviation LLC · Palmer, AKN901RGPrecision Aero Marine Inc · Plymouth, MAN90339Bas Part Sales LLC · Greeley, CON90608Hacker Henry · Mc Gregor, TXN94DFBesa Aircraft Corp · Lafayette Hill, PAN9510QRss Aviation LLC · Myrtle Beach, SCN9752QStrojny Andrew P Jr · Strongsville, OHN9780QWood William J · Jackson, GAN989KCNiner Kilo Charlie LLC · Tulsa, OK
Back to Smith AEROSTAR 601P