Lakewood, NJ
Registered aircraft · 27
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 = 'LAKEWOOD' 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 = 'NJ' AND g.registrant_city = 'LAKEWOOD' 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.
N12194Cessna 172M · S/N 17261875N128DVPiper PA-18A 150 · S/N 18-4366N2014PPiper PA-18 · S/N 18-4602N206NEBell 206B · S/N 441N2150APiper PA-18-135 · S/N 18-1862N247DPPiper J3C-65 · S/N 22825N285DSDiamond Aircraft Ind DA 40 · S/N 40.285N28JAPiper PA-28-181 · S/N 28-8290137N35762Piper J5A · S/N 5-753N4024JPiper PA-28-140 · S/N 28-7525271N40727Piper J5A · S/N 5-1159N40936Piper J3C-65 · S/N 7592N40JAPiper PA-28-161 · S/N 28-8616036N411EPCirrus Design SR22 · S/N 10607N41JAPiper PA-28-181 · S/N 2843081N4287QCessna 172L · S/N 17260187N42JACessna 172M · S/N 17267383N43JAMooney M20J · S/N 24-1519N44JAPiper PA-32-301 · S/N 32-8306031N571SFVans RV-12IS · S/N 12226N61WTCessna 172S · S/N 172S9818N6535HPiper J-3 · S/N 19722N738NYCessna 172N · S/N 17270119N749WWRaytheon HAWKER 800XP · S/N 258500N8519YPiper PA-18-150 · S/N 18-8885N93KKCessna 172M · S/N 17266160N9800WPiper PA-28-140 · S/N 28-23296
Back to Lakewood, NJ