OpenAirDocs.org
Fairfield, NJ

Registered aircraft · 35

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 = 'NJ' AND g.registrant_city = 'FAIRFIELD'
  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.

N108PTCessna 172S · S/N 172S10089Built 2005 · Henrie Aviation LLCN1493ECessna 172N · S/N 17271022Built 1978 · Sherman Aviation LLCN172YACessna 172P · S/N 17275080Built 1981 · Cf Images LLCN21200Cessna 182T · S/N 18281732Built 2005 · Paramus Flying Club IncN239JCirrus Design SR20 · S/N 2468Built 2019 · Nargis Aviation LLCN272LPCessna 172S · S/N 172S9272Built 2002 · Aa-Aero IncN3505TCessna 172S · S/N 172S8858Built 2001 · Aa-Aero IncN35148Cessna 172S · S/N 172S8930Built 2001 · Century Air IncN4202LCessna 172R · S/N 17280747Built 1999 · Aa-Aero LLCN453PTCessna 172P · S/N 17276262Built 1984 · Henrie Aviation LLCN49MQCessna 172N · S/N 17267703Built 1976 · Sgl Aviation LLCN506SPCessna 172S · S/N 172S8363Built 2000 · Henrie Aviation LLCN5133KCessna 172S · S/N 172S9002Built 2001 · Aa-Aero IncN52290Cessna 172P · S/N 17274484Built 1980 · Aa-Aero IncN5353KCessna 172P · S/N 17274078Built 1980 · Century Air IncN5635LAmerican AA-1 · S/N AA1-0035Built 1968 · Century Air IncN563SMCirrus Design SR22 · S/N 11476Built 2026 · D3 Aviation LLCN6189QCessna 172S · S/N 172S10738Built 2008 · Paramus Flying Club IncN66717Cessna 172P · S/N 17275991Built 1983 · Sherman Aviation LLCN677DMCessna 172S · S/N 172S9661Built 2004 · Aa-Aero IncN7049HCessna 182R · S/N 18267900Built 1981 · Air Bound Aviation LLCN70VHCessna 182N · S/N 18260765Built 1971 · Blue Sky Flyers LLCN711AVPiper PA-44-180 · S/N 44-7995215Aa Aero IncN720CGCirrus Design SR20 · S/N 9755Built 2023 · Third Aviation LLCN72MCCessna 182T · S/N 18281653Built 2005 · Aa-Aero IncN734RPCessna 172N · S/N 17269057Built 1977 · Cf Images LLCN73868Cessna 172N · S/N 17267730Built 1976 · Ca Aero LLCN763DYCirrus Design SR20 · S/N 1753Built 2006 · Sgl Aviation LLCN7866YPiper PA-30 · S/N 30-949Built 1965 · Henrie Aviation LLCN789PFCessna 172S · S/N 172S11115Built 2011 · Sherman Aviation LLCN792JHRaytheon 58 · S/N TH-1988Built 2001 · Elgee Aviation LLCN8050JCessna 182T · S/N 18281633Built 2005 · Paramus Flying Club IncN822BWPiper PA-44-180 · S/N 44-8195009Built 1981 · Aa-Aero IncN949KCDiamond Aircraft Ind DA 40 · S/N 40.949Built 2008 · Paramus Flying Club IncN9741FCessna 172R · S/N 17280036Built 1997 · Aa-Aero Inc
Back to Fairfield, NJ