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.
N777WVIndependent Mortgage · Westlake, LAN77XJDavid L Samani Md Inc · Lincoln, NEN792JHElgee Aviation LLC · Fairfield, NJN795ABSilver Mar LLC · Key Biscayne, FLN79CEBe 58 Corp · Rochester, NYN7PD426th Aero Squadron LLC · Cropwell, ALN823EFViperhawks LLC · Jacksonville, FLN828KMSjr Holdings LLC · Raleigh, NCN83KKLowe Aviation Co · Macon, GAN854CBeasley Timber Co Inc · Hazlehurst, GAN858WGreat Pond LLC · Bedford, MAN870UOhio University · Albany, OHN871JBAas Baron LLC · Houston, TXN873JDBank Of Utah Trustee · Salt Lake City, UTN874JETc Air LLC · Williamson, WVN875JGN875jg LLC · Lawton, OKN879JPRebel Aircraft LLC · Rapid City, SDN87RGCannon William C Jr · Concord, NCN889FTMolly Willis Ventures LLC · Albany, GAN8955ZSimmons Louis Crispin · Williamsburg, VAN8URLoberg Kirk · Jonesboro, ARN902DRBaron Dreams LLC · Inlet Beach, FLN909CMFlightpath LLC · Montgomery, NYN910SAPersistent Roots LLC · Carpentersville, ILN910WWLundell Plastics Corp · Odebolt, IAN94TJHuber Robert T · West Chester, PAN951POncourse LLC · Miami, FLN957PCPilot Realty Inc · Sackets Harbor, NYN958HCHydroair LLC · Auburn, ALN958WDBrush Art Corp · Downs, KSN971PDSpyglass Aircraft LLC · Milford, CTN976SRMs Baron LLC · Oxford, MSN979SSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN980PADesantis Anthony · Memphis, TNN987JSAmerican Star Aviation LLC · Ithaca, NYN999SKWkqm LLC · Wilmington, DEN99WTSudick Daniel · Dadeville, ALN9LTRegistered aircraft
Back to Raytheon 58