Mclean, VA
Registered aircraft · 54
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 = 'MCLEAN' 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 = 'MCLEAN' 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.
N120RLBeech 200T · S/N BT-9N124LDSchleicher ASW-24B · S/N 24250N1297LCirrus Design SR22 · S/N 0713N1733GBeech P35 · S/N D-6949N178DKAmerican Champion 8KCAB · S/N 1178-2018N208MGCessna 208B · S/N 208B5162N235HKShark Aero S R O SHARK UL · S/N 023N2433UCessna T182T · S/N T18208006N2521LCessna 172H · S/N 17255721N25PFPiper PA 46-350P · S/N 4636162N269ZPiper PA-32R-301T · S/N 3257407N280LMIai GULFSTREAM G280 · S/N 2054N2ZBeech A36 · S/N E-2514N328PMPatrick Mayworm VELOCITY XL-RG · S/N 3RX116N32NHTextron 208B · S/N 208B5360N3372MPiper PA-28-236 · S/N 28-8011059N363AEFairchild M-62A · S/N T43-7208N37RDCirrus Design SR22 · S/N 8624Sale reportedN38752Piper PA-32R-300 · S/N 32R-7780468N3882ASchweizer SGS 1-26A · S/N 44N40KGBeech A36 · S/N E-2067N4158KRyan NAVION · S/N NAV-4-1158N4673FCessna P206A · S/N P206-0273N500TSTextron 525C · S/N 525C0194N502CSCessna 337A · S/N 337-0280N50EDRolladen-Schneider LS8 · S/N 8004N519BHGulfstream Aerospace GVI (G650ER) · S/N 6553N591SRBombardier BD-700-1A10 · S/N 60105N60810Boeing D75N1 · S/N 75-3784N611MGCessna M337B · S/N 337M0081N611TBPiper PA-46-600TP · S/N 4698011N61818Boeing A75N1(PT17) · S/N 75-4751N63MKAircraft Mfg & Development CH 2000 · S/N 20-0051N659FMDassault FALCON 2000EX · S/N 045N669PSDiamond Aircraft Ind DA 40 · S/N 40.699N676NMooney M20C · S/N 680032N677JACessna 172S · S/N 172S10677N719DZN719dz SLING TSI · S/N 664SQN719RKCirrus Design SR22T · S/N 11114N72116Cessna 140 · S/N 9281N72626Cessna T206H · S/N T20608275N81282Walter Stanley Malinowski RV-14A · S/N 001N83947Piper PA-28-181 · S/N 28-8190247N850JPHawker Beechcraft HAWKER 850XP · S/N 258852N85918Cessna 337D · S/N 337-1023N859GABeech 200T · S/N BT-12N8622RSchweizer SGS 1-23H-15 · S/N 58N900LPDassault-Breguet MYSTERE FALCON 900 · S/N 20N9010FHughes 369H · S/N 190004N90CXRaytheon C90A · S/N LJ-1583
Back to Mclean, VA