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.
N6032VLawler Craig R · Milton, PAN6035BMontgomery Aviation Corporation · Montgomery, ALFirst renewal noticeN6036GBulldawg Aviation LLC · Helena, MTN60394Sears Brothers Farming · Joes, CON60527Smith Sidney R Trustee · Rllng Hls Est, CAN6056YDiesel Flying LLC · Wilmington, DEN6064SYasechko James Edward · Bonaire, GAN6069SNelson Ronald E · Richmond, TXN6070SEdward C Kole · Lake Geneva, WIN6072SMiller Walter Timothy · Henderson, NVN6092SRobinson David John · Eads, TNN6093SFarmer Scott · Springtown, TXN60MLStephens Gary James · Austin, TXN60RMMartin Bennie D · Garden Ridge, TXN6123XBuffalo Aviators LLC · Denver, CON61487Vspeed LLC · Saint Paul, MNN614LGleason Gregory C · Ennis, MTN6176UHallman David M Jr · Erie, PAN6198USeldom Seen LLC · Kalispell, MTN61DBBorror Sean L · Palmdale, CAN61JLSweeney Michael Patrick · Lagrange, GAN624DKFw Cielo LLC · Canton, OHN6267XWahlen Per · Newtown Square, PAN627AJJorfam Properties LLC · Dripping Springs, TXN62BJCapital Dental Management Inc · Dover, DEN6318STilbury Mitchell Allen · Blaine, MNN635APLambert Kurt P · Albuquerque, NMN6361CMaples Lee Trustee · Belle, MON6370SFreeland Christopher G · Brownwood, TXN6397SIts Allgood Air LLC · Lewes, DEN64098Sottile Joseph Jr Trustee · Chandler, AZN6409SWas He Slow LLC · Chagrin Falls, OHN641GWalrabenstein Eric S · Glendale, AZN6428SWickboldt Michael P · Woodland, CAN6551CChurch Thomas · Lenoir, NCN659TLucy Donald E III · Newbury Park, CAN65YLippman Thomas N Trustee · Brisbane, CAN6621SOverbey Michael C · Watkinsville, GAN6625RBeech South LLC · Kalispell, MTN66409Dans Flying Service Inc · Crookston, MNN6640LHyder Steven Richard · Albuquerque, NMN6641RWightman William Adams Jr · Yukon, OKN66421Gleim Garrett William · Gainesville, FLN6643QSky High Solutions Inc · Miami, FLN6646SHolub James T · Wellington, FLN6648NMark & David LLC · Coldwater, MSN6649SRay James William · Albert, NMN664HWWilliamson Kemal · O Fallon, ILN664TBechtol Andrew M · Long Beach, CAN6652DRafter B Cattle Company LLC · Gordonville, TX
Back to Beech V35B