Orange Park, FL
Registered aircraft · 43
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 = 'FL' AND g.registrant_city = 'ORANGE PARK' 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 = 'FL' AND g.registrant_city = 'ORANGE PARK' 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.
N110PPhillips CAVALIER SA-102.5 · S/N 6888N1311SCessna 182P · S/N 18264876N15968Piper PA-28-180 · S/N 28-7305200N17CGGray Charles B GLASAIR III · S/N 3133N201BZMooney M20J · S/N 24-0437N21JBWeller Jay Bee STS PLYMATE SA-11-A · S/N 171011242N2907EAeronca 7AC · S/N 7AC-6490First renewal noticeN303TDDuke Terry A VANS RV-8A · S/N 81763N306RSCirrus Design SR22 · S/N 4743N345RLLearjet 45 · S/N 180N345RWWickworks CORBEN BABY ACE · S/N 2002N35247Cessna 177B · S/N 17702289N357TWBombardier BD-100-1A10 · S/N 20314N358ESCessna 172R · S/N 17280008N364DBBeech A36 · S/N E-2963N3858VCessna 150M · S/N 15076637N3956AChampion AERONCA L-16B · S/N 7CCM-50N4185WPiper PA-28-181 · S/N 2843417N42GFPeterson Douglas W VANS RV6 · S/N 23925N50790Cessna 150J · S/N 15069556N5094BSmith Glenn E PIETENPOL BIPLANE · S/N 001N542MAPiper PA-28-161 · S/N 28-7816364N5491HCessna 172M · S/N 17265463N55KJBeech 58TC · S/N TK-40N60693Cessna 150J · S/N 15070506N6091WPiper PA-28-140 · S/N 28-20105N657TBMooney M20B · S/N 1901N65TKPiper AEROSTAR 601P · S/N 61P06697963313N66111Cessna 172Q · S/N 17275967N688ERCirrus Design SR22T · S/N 0745N69620Boeing A75N1(PT17) · S/N 75-3510N7230KCoppen Walter Gary SA-7 · S/N GC112051N7311KCirrus Design SR22 · S/N 4125N747RNAlgen Albritten SLING TSI · S/N 155SKN76058Cessna 140 · S/N 10452N771AJRichards Uh1k H-1 · S/N 001N77KGBeech F33A · S/N CE-486N8031ZTeeter Gregory Eugene SA-3B · S/N P-354N82JJPiper PA-28RT-201T · S/N 28R-8031125N84113Aeronca 7AC · S/N 7AC-2800N86ABellanca 14-13-2 · S/N 1211N8943NPiper PA-32-300 · S/N 32-40744N9559MMooney M20F · S/N 670136
Back to Orange Park, FL