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 ('1151538')
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 ('1151538')
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.
N2041WJimenez John D · San Antonio, TXN2047WKapusta Marian · Clearwater, FLN2048WTripi Mark DBA · Parkersburg, WVN2049WHufford P Thomas Trustee · San Diego, CAN2053WOem Products Inc · Oklahoma City, OKN2054WVerran Clinton T · Rochester Hills, MIN2058WSweet Fred A · Loves Park, ILN2059WMorgan Jeffrey B · Edgewater, FLN2060WBreskman David G · King Of Prussia, PAN2062WMichalka James R · Portage, MIN2072WNewsome Jeff · Blackwell, OKN2073WPlowden William E Jr · Shelby, NCN2075WCooper Jeffrey B · Eagle River, AKN2080SRobinson Earl J · Cotuit, MAN2081WN5724v LLC · Kalispell, MTN2082WRegistered aircraftN2084WBurkett James Austin III · New Port Richey, FLN2092WEarthcirc08 LLC · Chagrin Falls, OHN2093WKliewer Silas M · Ulm, MTN210RMace Steven B · Ocala, FLN215YHodgson Mark · Fox Point, WIN21SHFlight Less LLC · Helena, MTN228QDodson International Parts Inc · Rantoul, KSN229QMike Lima Partners LLC · Wilmington, DEN22TNNewman William L · Breckenridge, TXN22XFishburn James R III · Wooster, OHN22XGPixton Thomas J · Incline Village, NVN231SVinegaroon Aviation LLC · Franklin, TNN234EBArbuckle James H · Bellevue, NEN235RRegistered aircraftN24WKCannizzaro Charles DBA · North Syracuse, NYN258TCDunn Mark A · Lufkin, TXN260AACarpenter Timothy A · Phoenix, AZN2667Marlow Air LLC · Gilmanton Iw, NHN2701TGray Stephen T · Lafayette, CAN2714TVertical Flight Leasing LLC · Wilmington, DEN2720TMiller Mark · Bellevue, WAN2721TGalvin Peter · Laytonsville, MDN2728TMilk Ranch LLC · Stephenville, TXN2729TWasileski David J · Auburn, NYN272SBofinger Jr John M · Hewitt, NJN2731TFocus LLC · Missoula, MTN2735TWhite Michael W · Key Largo, FLN2736TM & N Leasing Co · Marietta, GAN2739TPickering Kevin P · Lakeland, TNN2746TFranklin Ronald C · Las Vegas, NVN2749TCaudle Nathan · Fort Worth, TXN274SScott Joseph Brian · Sarasota, FLN27550Anderson Herman A · Basalt, CON2759TLopas Jon D Trustee · Prescott, AZ
Back to Beech V35