Arlington, VA
Registered aircraft · 82
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 = 'VA' AND g.registrant_city = 'ARLINGTON' 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 = 'VA' AND g.registrant_city = 'ARLINGTON' 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.
N1142FCessna 172G · S/N 17254737First renewal noticeN117PWPiper PA46-500TP · S/N 4697030N11ARGulfstream Aerospace GV-SP (G550) · S/N 5351N130TMCompagnie Daher TBM 700 · S/N 1385N1420MBoeing E75N1 · S/N 75-8503N167BPThompson David THUNDER MUSTANG · S/N JITM-029N1897EBeech V35 · S/N D-8313N1WHHays Peter G HAYS SKYBOLT · S/N 1N209TGGregory Donald Sutton SLING 2 · S/N 273KN2104UPiper PA-28-181 · S/N 28-7990327N2292MPiper PA-28R-201 · S/N 28R-7837081N245WCCirrus Design SR22 · S/N 11363N2512BAeronca 7CCM · S/N 7CCM-98N266TPiper PA46-500TP · S/N 4697188N280RABeech 200 · S/N BB-53N332ADCirrus Design SR20 · S/N 10710N335SJLearjet 60 · S/N 335N33BKTextron 525B · S/N 525B-0514N359MBRaytheon B300 · S/N FL-359N362BPPiper PA-23-250 · S/N 27-7954048N362DADiamond Aircraft Ind DA 62 · S/N 62.C056N367STRaytheon B300 · S/N FL-341N36913North American T-6G · S/N 49-3171N3794VCessna 140A · S/N 15215N4114YBellanca 7GCBC · S/N 947-76N411CFPiper PA-31-300 · S/N 31-339N418KMMaule M-7-235C · S/N 25075CN41FRBeech A36 · S/N E-371N444RABeech B-19 SPORT · S/N MB-810N452VACirrus Design SR22 · S/N 4776N471USBoeing 737-8 · S/N 61329N472USGulfstream Aerospace GVI (G650) · S/N 6198N473USGulfstream Aerospace GVI (G650ER) · S/N 6242N474USBoeing 737-7H4 · S/N 36623N475USBoeing 737-752 · S/N 33789N476USBoeing 737-7H4 · S/N 36626N477USBoeing 737-752 · S/N 33785N478USBoeing 737-7H4 · S/N 30677N479USBoeing 737-7H4 · S/N 36617N480USBoeing 737-7H4 · S/N 29843N517HJames A Hart RV-10 · S/N 42219N5270Boeing B1E · S/N 1028N5383QCessna 150L · S/N 15073283N6018QMooney M20E · S/N 868N601DHHerndon Richard J ZODIAC CH 601 HDS · S/N 6-3849N603NDCessna 172S · S/N 172S11254N6108JRolladen-Schneider OHG LS1-F · S/N 272N6122VMichael C Vadney CARBON CARL · S/N 089First renewal noticeN6140VVadney Mike VORTEX · S/N 88First renewal noticeN625BWBeech B200 · S/N BB1090
Back to Arlington, VA