Fairfax, 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 = 'FAIRFAX' 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 = 'FAIRFAX' 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.
N1004DMaule M-7-260 · S/N 26001CN10797Cessna T206H · S/N T20608525N11468Waco QCF · S/N 3541N211FXBell Helicopter Textron Canada 429 · S/N 57004N212FXBell Helicopter Textron Canada 429 · S/N 57055N215GDLogos Technologies MTOSPORT · S/N M01873N215LTLogos Technologies AUTOGYRO MTO SPORT · S/N M01215N261DSDiamond Aircraft Ind DA 40 · S/N 40.924N265SJBombardier BD-100-1A10 · S/N 20308N2734TMccombs Bruce A LITTLE WINGSAUTOGYRO · S/N MC5N273AGulfstream Aerospace GV-SP (G550) · S/N 5273N28VMHawker Beechcraft HAWKER 900XP · S/N HA-0204N291SGSocata TB-20 TRINIDAD · S/N 1032N3096EAeronca 7AC · S/N 7AC-6685N33573Piper J3C-65 · S/N 14050N361VRVashon RANGER R7 · S/N 10215N3852DPipistrel Doo Ajdovscina VIRUS SW · S/N 632 SWN 100ISN3859TPiper PA-28R-180 · S/N 28R-30182N38812Piper J3L-65 · S/N 7298N41209Piper PA-28-180 · S/N 28-7405071N4697ZPiper PA-22-108 · S/N 22-8237N4699JPiper PA-28R-180 · S/N 28R-30602N4786NBoeing A75N1(PT17) · S/N 75-3293N523AJHawker Beechcraft 400A · S/N RK-523N5295SPiper PA-28-140 · S/N 28-26941N529JKCessna 182Q · S/N 18265525N53LDCessna 170B · S/N 25599N60326Cessna 150J · S/N 15070227N60607Cessna 150J · S/N 15070441N6212GCessna 172N · S/N 17273579N628GIai GULFSTREAM G280 · S/N 2097N6645JPiper PA-28-180 · S/N 28-5131N66472Cessna 150M · S/N 15076072N68253Boeing A75N1(PT17) · S/N 75-2416N6999DMooney M20C · S/N 2705N7042ACessna 172 · S/N 29142N70561Piper J3C-65 · S/N 17570N732BNLake LA-4 · S/N 252N734QTCessna 172N · S/N 17269037N738PDCessna 172N · S/N 17270123N75PLThomas PAZMANY PL-2 · S/N 113N786WBCirrus Design SR22 · S/N 4963N80UAJames F Ryan RYAN EAGLE · S/N 3191954N812BEPiper PA-32R-301T · S/N 3257115N8242XCessna 172C · S/N 17248742N824ARCirrus Design SR22T · S/N 2474N8251WPiper PA-28-180 · S/N 28-2401N8562MBeech 35-B33 · S/N CD-653Sale reportedN874DEErickson Donald L RV-8 · S/N 81860N8769ZCessna 177RG · S/N 177RG1358
Back to Fairfax, VA