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 ('1151410')
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 ('1151410')
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.
N5499UDavis Bret K · Boynton Beach, FLN5614SShaughnessy William · Rochester, MNN5615SBradley A Eli Dental Corp · Encinitas, CAN5629SMostafa Nagy Hassan · Oceanside, CAN5630SBell Steve · Broken Bow, OKN5631SThompson Clay · Altus, OKN5664KEchols Charlotte · Wichita Falls, TXN567ZZulu Aerospace Services LLC · Prescott, AZN5722VShank Joel F · Brawley, CAN5725VCrumly Chris P · Woodlake, CAN5728VGlenn Metalcraft Inc · Princeton, MNN5734VAranda Carlos Javier · Orange, CAN5735VRay Brian · Peoria, ILN5924SN5924s LLC · Fayetteville, GAN612TTCashin Timothy J · Santa Monica, CAN638SDebonair N638s Flying Club LLC · Beavercreek, OHN66DRInternational Air Services Inc Trustee · Carson City, NVN69SHInception Aviation LLC · Waco, GAN6KRWatters James · Dwight, ILN721CGJohnson Charles G · Jackson, MSN721EBBiggs Aircraft Inc · Wellston, OKN747BGMiller Bradley W · Conyngham, PAN753BDistefano John · Bayville, NJN7583COrantes Alexander · Van Nuys, CAN761JTStahlberg Jeffrey C · Blissfield, MIN7880LSw Aviation Group LLC · Dover, DEN7891LGrr Aviation LLC · Grand Rapids, MIN78CCRaggstr Enterprises LLC · Boise, IDN7903MNichols Andrew · Harrells, NCN7907MShipman Johnny R · Sealy, TXN7915MBlue Sky Aviation LLC · Northport, ALN7951MBrown David E · Bell Buckle, TNN7962MPadikins Inc · Wilmington, DEN7978MRegistered aircraftN7984M84m LLC · Bixby, OKN7991MTrapp Brian W · Lebanon, OHN7993MZiebarth William R · Powell, OHN7995MBowers Kevin · Lawrenceville, GAN7996MHager Terry L · Texhoma, OKN799XSemanskee Grant W · Snohomish, WAN7ASLittle Karley Y · Baytown, TXN822MLay Karl I · Granada Hills, CAN88KSHolzschuh David D · Corpus Christi, TXN88YYSauer Stuart O · Fort Mohave, AZN8BNHopkins Darren M · Aiken, SCN916NLundberg John A · Palos Verdes Est, CAN922SCWood James A · Madera, CAN9451SBurnside Joseph E · Sarasota, FLN9457SBishop Raymond E · Darien, ILN9460SFrosig Jared · Odessa, TX
Back to Beech 35-C33A