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 ('7150007')
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 ('7150007')
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.
N844CAWilmington Trust Co Trustee · Wilmington, DEN84LELife Logistics LLC · Chesterfield, MON864CACarver Aero LLC · Muscatine, IAN865LRKirmart Inc · Wichita Falls, TXN883GBTica Travel LLC · Tampa, FLN888FMLasai Aviation LLC · Reston, VAN888HTFortenberry Aviation LLC · Crossville, ALN88HRHansen Ranches LLC · Corcoran, CAN899JEN899je LLC · Rollins, MTN902MHMansfield Heliflight Inc · Milton, VTN903JBigups Aviation 010 LLC · Valley Village, CAN907EJBarrel King LLC · North Palm Beach, FLN911CACalifornia Highway Patrol · Sacramento, CAN919BWIcm Inc · Colwich, KSN930DSAc Aircraft Holdings LLC · Dallas, TXN933CAMetrea Special Aerospace Isr Inc · Bethany, OKN935BDDiamond Aviation LLC · Dublin, GAN938BSBlue Star Gas Fleet Services Co · Santa Rosa, CAN938SBCavu 350 LLC · Stuart, FLN944XCMojave Jet LLC · Nolensville, TNN945SHShelter Enterprises LLC · Columbia, MON949KAGavair LLC · Pagosa Springs, CON950MHSpotted Hawk Aviation LLC · Gunnison, CON971LLState Of Illinois · Springfield, ILN978TSWaxhaw Flyers LLC · Rosedale, MSN980BCJet Rider LLC · Wilmington, DEN981LLState Of Il Dot · Springfield, ILN983ARS2c LLC · Wilmington, DEN984RPShippy Aviation LLC · Henderson, CON988SCPallair LLC · Harlingen, TXN991LLState Of Illinois · Springfield, ILN992MAJet Rider LLC · Wilmington, DEN994CFKk Air Leasing LLC · Tamarac, FL
Back to Raytheon B300