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 ('7150003')
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 ('7150003')
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.
N3033BPalms Edward M · Greenwood Village, CON3049DAnchor Equipment Leasing LLC · Covington, KYN3058ROn Top Aviation LLC · Salinas, CAN3066DN3066d LLC · Pompano Beach, FLN3075PWjs Inc · Greeneville, TNN316DFThacker Orbie A · Wellington, ALN3174TChartwell Services Inc · Wilmington, DEN3177WCraniatwo LLC · Peoria, ILN3182LN303cj LLC #1 · Lexington, KYN318CAKornegay Patrick · Harlingen, TXN3195KEasygoair LLC · Sudbury, MAN3196WTs Aviation LLC · Sioux Falls, SDN3199JSietsma Lawrence F · Indialantic, FLN3211UHc LLC · Troy, ALN324QLove Charles Keith · Asheville, NCN3261CHeyman Steven · San Mateo, CAN328MN328m LLC · Marion, INN328PStrother J Barron · Santa Rosa Beach, FLN338TKGranite Boarding LLC · Loomis, CAN33SHDrl Baron LLC · San Augustine, TXN345PGN345pg LLC · Chicago, ILN3566WGriffin Aviation LLC · Minneapolis, MNN360UAdrenalyne Consulting LLC · Scottsdale, AZN36TAN36ta LLC · Dover, DEN393FBRegistered aircraftN3MUAero Equities LLC · Ventura, CAN4124WGeaux Automotive Advertising LLC · La Place, LAN4298YAir LLC · Fresno, CAN42KWMarine Aviation LLC · Lyme, NHN42TBFlores Nicholas L Jr · San Antonio, TXN430RVVermejo Aviation LLC · Boulder, CON4324VTriple Aaa LLC · Garden City, KSN443PFrederick Investment Corp · Raleigh, NCN4482WWheels In The Well LLC · Jonesboro, ARN457BKForty Sixty Two B Inc · Lubbock, TXN468PN Fl Servicing LLC · Santa Rosa Beach, FLN46HW2j2g LLC · Wilmington, DEN476EWWny Air Inc · Dover, DEN500BAKw Plastics · Troy, ALN500TLSententia LLC · Highland Park, ILN504TBAutomotive Air III LLC · Belcamp, MDN5065RZ J Express LLC · Lewes, DEN5096RProvestment International LLC · West Melbourne, FLN509PTailwindsbikelyft LLC · Hannibal, MON50SSAviation Trust Company LLC Trustee · Oklahoma City, OKN515RGDowney Paul J · Newington, NHN517MRDgw Aviation LLC · Elverson, PAN520LLMesoamerica Aviation Corp · Wilmington, DEN521WSCmt Properties LLC · Laurel, MSN525TMVertivue LLC · Allentown, PA
Back to Raytheon 58