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 ('1151548')
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 ('1151548')
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.
N711NCHussey Aviation LLC · Clear Lake, IAN713MGMy Multifamily Investments LLC · Dallas, TXN713TTAbe Air LLC · Salinas, CAN71YLN825fg Corp Trustee · Wilmington, DEN7208RBelford Mark C · Sammamish, WAN720TMinter Michael D Jr · Rock Port, MON721WTop Flight Aviation LLC · Kingfisher, OKN725ADSisson David Brent · Lubbock, TXN725APSheets Douglas · Goodyear, AZN7274RChastain Phillip L · St Louis, MON727CBDwr Aviation Enterprises LLC · Vero Beach, FLN727EGTalor Darrell T · Dawsonville, GAN7286RHulands Gregory G · Eagle Point, ORN730SMStockmans Inc · Visalia, CAN731MLRomine George · Sahuarita, AZN735VThomas Stephen · Granbury, TXN7367RMockingbird Aviation LLC · Wilmington, NCN7369RDuman Ralph J · Cedarville, MIN7391REdm Corporation · Nevada, MON7397RWest Michael P · Colusa, CAN73DEHill Christopher Michael · Linden, TXN73RHBradley A Eli Dental Corp · Encinitas, CAN73VBVb Aviation LLC · Mount Pleasant, SCN747BPRose James M · White Hall, ARN74CBKendrick Paul · Atascadero, CAN755TAg Air Ltd · Harwood, NDN756TN756t LLC · North Royalton, OHN761LTFiddelman Joseph D · Port Orange, FLN762TFair Skies LLC · East Meadow, NYN766TDecesare George D · Danville, CAN769TPatterson David Roy · Lockney, TXN770THoyer Kyle E · Manassas, VAN771TFudge Justin · Karnes City, TXN775TSorensen Craig A · Fallon, NVN777BAGado Theodore A · Cortlandt Manor, NYN777CEMiller Dana · Tracy, CAN777PDIsr Aviation LLC · Wilmington, DEN777UPerez Michael Joel D · San Diego, CAN77BJHint Peter T · Centerport, NYN77CYN77cy LLC · Lambertville, MIN77FHCumbey Joseph S · Scroggins, TXN77QQBurkhardt Wayne W · Deming, NMN77VBMorgenroth Aviation LLC · Victoria, TXN77XFDuwane D Skipper · Booker, TXN7800YH&H Aviation Of Oklahoma LLC · Oklahoma City, OKN781LDKeane James P · West Islip, NYN7835VRoney John P · Charlotte, NCN783TMElliott Frank A · Oxford, MSN787JVRegistered aircraftN788KRegistered aircraft
Back to Beech V35B