La Porte, IN
Registered aircraft · 37
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 = 'IN' AND g.registrant_city = 'LA PORTE' 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 = 'IN' AND g.registrant_city = 'LA PORTE' 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.
N157PWRaytheon 400A · S/N RK-264N1804PPiper PA-22-150 · S/N 22-2583N21471Mears James R VANS RV4 · S/N 3426N2198MPiper J3C-65 · S/N 20989Sale reportedN2542RCessna 182K · S/N 18258242N2833ZPiper PA-22-150 · S/N 22-6828N295DEBeech D-50 · S/N DH-88N2ZWBeech G35 · S/N D-4564N300FPEmbraer Executive EMB-505 · S/N 50500277N30525Cessna 177A · S/N 17701303N3793UCessna 182G · S/N 18255193N37JVSutton James B AVID HAULER · S/N 456N421CRCessna 421B · S/N 421B0224N4311STL Ultralight Sro TL-3000 SIRIUS · S/N 19 SI 175N4359BCessna 170B · S/N 26703N443TTTyler H Thomas RV 4 · S/N 161N4567ZCirrus Design SR22T · S/N 10467N459RVMoore Joe D JR RV9A · S/N 021207N46019Cessna 172I · S/N 17256992N5049RCessna 172M · S/N 17263290N5107MBeech C23 · S/N M-2027N516AMVans RV-12IS · S/N 12141N522CDCirrus Design SR22 · S/N 0193N5314KCessna 172P · S/N 17274060N53TAPiper PA-31T · S/N 31T-7820083N59PPMooney M20A · S/N 1646N61LBBober Ronald J LANCAIR SES · S/N 61N65RTBeech 200 · S/N BB-97N6937SCessna 150H · S/N 15067637N761LUCessna T210M · S/N 21062348N80340Cessna 172M · S/N 17266534N8288FPiper PA-28-181 · S/N 28-7790237N84306Aeronca 7AC · S/N 7AC-3001N845RBeech 35-33 · S/N CD-109N8586RBeech F33A · S/N CE-540First renewal noticeN952BGGarry Steven Edson AIR BIKE · S/N 23N98862Piper J3C-65 · S/N 19120
Back to La Porte, IN