Liberty, NC
Registered aircraft · 62
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'NC' AND g.registrant_city = 'LIBERTY' ORDER BY g.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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'NC' AND g.registrant_city = 'LIBERTY' ORDER BY g.n_number
Run 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.
N101CUDJI MATRICE 600 PRO · S/N M80DFK05030011N102VRCessna 750 · S/N 750-0102N108RLRaytheon HAWKER 800XP · S/N 258619N118DBBombardier BD-100-1A10 · S/N 20071N125DZCessna 750 · S/N 750-0079N125THCessna 750 · S/N 750-0177N136DBBombardier BD-100-1A10 · S/N 20222N161DBBombardier BD-100-1A10 · S/N 20302N186DBBombardier BD-100-1A10 · S/N 20342N191RDDJI AGRAS T20P · S/N 1581F574B227B00100VMN192AMPiper PA-28-181 · S/N 2881507N201HRCessna 750 · S/N 750-0024N205DBBombardier BD-100-1A10 · S/N 20074N206DBBombardier BD-100-1A10 · S/N 20160N210DBBombardier BD-100-1A10 · S/N 20128N2236PPiper PA-23 · S/N 23-845N2492ADJI AGRAS T40 · S/N 64TBL4A00200BBN285DCDJI AGRAS T20P · S/N 64UBL81002005FN301HRCessna 750 · S/N 750-0062N32103Piper PA-28-180 · S/N 28-7505026N34CCBeech T-34C-1 · S/N 86N370DBBombardier BD-100-1A10 · S/N 20056N371DBBombardier BD-100-1A10 · S/N 20064N372DBBombardier BD-100-1A10 · S/N 20055N373DBBombardier BD-100-1A10 · S/N 20057N385DBBombardier BD-100-1A10 · S/N 20041N416FBombardier BD-100-1A10 · S/N 20262N44040Taylorcraft BC12-D · S/N 9840N4972ZPiper PA-22-108 · S/N 22-8570N513JBCessna 750 · S/N 750-0129N517CFCessna 750 · S/N 750-0049N51GBCessna 750 · S/N 750-0142N526FXBombardier BD-100-1A10 · S/N 20118N528FXBombardier BD-100-1A10 · S/N 20125N530FXBombardier BD-100-1A10 · S/N 20148N531FXBombardier BD-100-1A10 · S/N 20150N532FXBombardier BD-100-1A10 · S/N 20154N541FXBombardier BD-100-1A10 · S/N 20211N542FXBombardier BD-100-1A10 · S/N 20217N5497DDJI AGRAS T50 · S/N 63YWN5E00226HDN549FXBombardier BD-100-1A10 · S/N 20374N552FXBombardier BD-100-1A10 · S/N 20084N553FXBombardier BD-100-1A10 · S/N 20236N632BZPiper PA-44-180 · S/N 4496632Registration pendingN68167Cessna 152 · S/N 15282159N700LHCessna 750 · S/N 750-0148N70PBPiper PA-23-250 · S/N 273146N733FLCessna 750 · S/N 750-0027N757MYCessna 152 · S/N 15279860N7739GCessna 172L · S/N 17259439
Back to Liberty, NC