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 ('1380144')
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 ('1380144')
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.
N66414Daunt David B · Simi Valley, CAN66417Lowe Thomas E · Crystal Lake, ILN66418Johnson Lawrence F · Felton, DEN66461Garcia Roberto P · Spring Hill, FLN66607Platts Thomas S · Oregon, WIN66992Heritage Air Corps Inc · Des Plaines, ILN67344Regent Trust Corp Trustee · Wichita, KSN67823Registration Pending · Wichita, KSRegistration pendingN68135Hubbard Mark A · Wilmington, DEN68162Pozanac Charles J · Riverside, CAN68224Pozanac Charles J · Riverside, CAN68235Moburg Kenneth Dean · Basehor, KSN68238Radial Rogues Inc · Chandler, AZN68324Registered aircraftN68405Mason Michael S · Sequim, WAN6848Tataryn Roderick W · Valleyford, WAN6875SSmith Thomas A Trustee · Rogersville, ALN68800N68800 LLC · Mesa, AZN68837Somes Jason · Newbury Park, CAN68838Krogmann Kurt G · Somerset, WIN68941Aerospace Trust Management LLC Trustee · Wilmington, DEN68958Eberlesrock USA LLC · Boise, IDN68972Biplane Engineering LLC · Oakland, NJN68993Nelson Eric W · Louise, TXN68994Miller Bryan D · Tampa, FLN68WCas Aerobatic LLC · Carthage, MON69176Schaller Neil J · New Athens, ILN69182Planeview Aviation Services Inc · Ahoskie, NCN69389Moore Enterprises Leasing Inc · Indianapolis, INN69626Larson Lynn R · Casselton, NDN69652Ageless Aviation Dreams Foundation Inc · Carson City, NVN69706Air Cav Helicopters LLC · Wilmington, DEN69766Thornburg Tim W · Union City, INN69808Newman Brian A · Caldwell, IDN69866Sellers Ron · Emporia, KSN69991Jko Aviation LLC · Helena, MTN69GLargen Gregory K · Benton, KSN73410Eastern Stearman Inc Trustee · Leesburg, VAN73437Aerospace Trust Management LLC Trustee · Wilmington, DEN73583Garber Bruce E Trustee · Sheridan, WYN735YPJwe Aviation LLC · Carmel, INN73621Continental Title Trust LLC · Wichita, KSN747RBSloan Donald W · Dover, DEN75035Case3 LLC · Kirksville, MON75052Duplantis David L · Lafayette, LAN7520Davidson Craig M · Danville, ILN75227Morelock Colleen P Trustee · Beavercreek, OHN75236Migura David G · Del City, OKN75520Mcaleer William V Jr · Locust Grove, GAN75546Aircraft Guaranty Corp Trustee · Oklahoma City, OK
Back to Boeing B75N1