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 engine_model_code IN ('63601')
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 engine_model_code IN ('63601')
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.
N550YNixon Edward J · Collierville, TNN550YKSkorost LLC · Scottsdale, AZN552BMN522bm LLC · Commerce City, CON552CYRietdyk Guido · Rancho Dominguez, CAN552SHM & R Holdings LLC · Montgomery, ALN552WHHallstrom Warren C · North Little Rock, ARN556TREkberg Craig T · Rolling Hills, CAN55XZSimply Living LLC · Fort Myers, FLN55YADay Iain A · Brewster, MAN55YFWorldwide Warbirds Inc · Midway, UTN55ZXEverill Kenneth A · Mckinney, TXN5616NBatliner Paul J · Faucett, MON58GCFarrell Grant B · Lake Forest, ILN59YRN59yr Corp Trustee · Wilmington, DEN5MSKrause Jason · Glendale, AZN60516Connolly Luke A · Blaine, MNN6161TFlying Low Racing LLC · Oklahoma City, OKN6170CBarrett Neville P E Trustee · Miami, FLN6199UBalkin John S · Bigfork, MTN6209FKnolla John L · Andover, KSN620DMStrosnider Darrin R · Bozeman, MTN622WDBuseman Joel L · Belmond, IAN626MXLiu Weston B · Brookline, NHN6397ZGrant Roderick M · Dillingham, AKN6398ZRed X Yak Inc · Troy, OHN63YKScheinblum Carissa · Collierville, TNN64WEWolfenden Enterprises Inc · Vero Beach, FLN65NLVnat Inc · Orlando, FLN666YKLaughlin Richard C Jr · Boerne, TXN694YKBozek Philip T · Brighton, MIN699SUHammerhead Aerobatics · Wilsonville, ORN69CYRed Bandit LLC · Phoenix, AZN69KLAerobatics Inc Trustee · Wilmington, DEN7074LHladik Alexander Thomas · New Smyrna Beach, FLN7090LMedore Douglas A · Romoland, CAN713YKSteiger Jon P · Friendswood, TXN717SEHartman Christopher S · Navarre, FLN745LLLuckinbill LLC · Columbus, MTN748JSAugust Aero LLC · Kalispell, MTN752YKG-Loc Fighters LLC · Wilmington, DEN7677Warbirds Of The World Air Museum · Los Lunas, NMN7694BJohnson Evan J · Albuquerque, NMN777YKEllison Mathew D · Lincoln, NEN79RUWorld Aviation Museum Corp · Woodville, WIN8018TRegistration Pending · Goodland, KSRegistration pendingN805DFBella Mia Aero LLC · Santa Rosa Beach, FLN8120CMichalak Michael T · Independence, ORN812MSCocchiola Bart · Pittstown, NJN815YKElminoufi Gary · Redondo Beach, CAN8181CChi-Com Aviation LLC · San Tan Valley, AZ
Back to Vedeneyev M14P