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.
N53RTCas Capital Holdings LLC · Newark, DEN543RBBaron Aviation LLC · Calera, ALN552CKDeep South Management LLC · Douglas, GAN558THScannelli Jeff · Southampton, NYN574HALow Approach LLC · Wilmington, NCN574KKurz Douglas · Houston, TXN574WDLathrop Frederic W · Dayton, OHN575CWWheeler Dealer LLC · Wilmington, DEN580AHMadeline Inc · Clarkston, MIN580BXPreferred Management Corp · Shawnee, OKN581AFAirtrust LLC 11 Series 11 Trustee · Sheridan, WYN581LCCougar Inc · Ridgeland, MSN581PSBonanza Aviation LLC · Wilmington, DEN581RFFrederick Ronald M · Dallas, TXN581SACalifornia Industrial Rubber Co Inc · Fresno, CAN581SHShowtime Aviation LLC · Frostproof, FLN588ANCalifornia In Nice Inc DBA · San Jose, CAN58BESouth Georgia Air LLC · Valdosta, GAN58GFCollier Air LLC · Fernandina Beach, FLN58GWAlpha Whiskey LLC · Easton, PAN58HWHotel Whiskey LLC · Sylvania, OHN58KTBarron Equipment Leasing LLC · Port Washington, NYN58NDNorth Dallas Aviation Inc · Addison, TXN58SZRising Wings Aviation LLC · Walnut Creek, CAN5ZRBeasley Timber Co Inc · Hazlehurst, GAN600RVAero-Tech Services Inc · Lititz, PAN605CCommerce Landing Aviation LLC · Tampa, FLN612KPSmith Aviation Inc · Stamps, ARN621DEDesert Excavating Inc · Yuma, AZN629CJEssex Aircraft Management LLC · Randolph, NJN639ARBraden Health LLC · Greensboro, NCN645SKBendavid Gary · Oak Bluffs, MAN64WRAlesia Holdings LLC · Beaumont, TXN65LMAero Compression LLC · Macon, GAN65MH993 LLC · Davidson, NCN663JMCh Aviation LLC · Wilmington, DEN6644KRrc Upper Freehold LLC · Farmingdale, NJN699PSMcmillen Yachts Inc · Newport, RIN69CLTspy Services Inc · Nicholasville, KYN721CVDvf Ventures LLC · Alapaha, GAN7318ABaron Associates LLC · Norfolk, VAN731JAMccallister Aviation Rentals & Sales LLC · Qulin, MON731JPParker Aviation LLC · West Chicago, ILN731PCapital Dental Management · Medford, ORN732P626cf LLC · Lynchburg, VAN73CAShelor Investments LLC · Christiansburg, VAN747DWAviation Trust Company LLC Trustee · Oklahoma City, OKN753DMAcid And Cementing Inc · Palestine, TXN755GHJeff Hux Farms LLC · Sikeston, MON758PBas Part Sales LLC · Greeley, CO
Back to Raytheon 58