New Iberia, LA
Registered aircraft · 44
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 = 'LA' AND g.registrant_city = 'NEW IBERIA' 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 = 'LA' AND g.registrant_city = 'NEW IBERIA' 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.
N1095UCessna 172M · S/N 17266844N134MHMaule M-7-260C · S/N 30055CN13FMCessna L-19E · S/N 24590N147KCessna 182P · S/N 18264068N169PJLancair LC41-550FG · S/N 41065N1885QCessna 177RG · S/N 177RG0285N192LWPiaggio P180 · S/N 1199N2043CSchweizer 269C-1 · S/N 0329N206PHBell 206B · S/N 431N220CGRaytheon B300 · S/N FL-397N223EASocata TBM 700 · S/N 323N253DSPiper PA-31-350 · S/N 31-8052142N2598WMooney M20E · S/N 949N293BGSikorsky S-92A · S/N 920221N314AQDJI AGRAS T50 · S/N 1581F6BUB2354001024WN337GMCirrus Design SR22T · S/N 11185N34246Taylorcraft BC12-D · S/N 7710N367ALDJI AGRAS T25 · S/N 63NCM5R0031PC1N380BContinental Copters-Darling EL TOMCAT MK-5A · S/N MHTC-7N41DBLewis Michael E RV-9A · S/N 90710N521HCVans RV-12 · S/N 120432N53165Boeing A75N1(PT17) · S/N 75-2853N543MLDenison Roland J JR SONERAI 1 · S/N 001N592BGSikorsky S-92A · S/N 920243N63032Aerostar International RX 8 · S/N RX8-3071N639BGAgustawestland Philadelphia AW139 · S/N 41343N643RSHawker Beechcraft G36 · S/N E-3849N692BGSikorsky S-92A · S/N 920093N70913Cessna 182M · S/N 18259416N7175HPiper J3C-65 · S/N 20432N739BGAgustawestland Philadelphia AW139 · S/N 41350N7559DPiper PA-22-150 · S/N 22-5290N760BGSikorsky S-76C · S/N 760733N77SXSnyder Dan RANS S-16 · S/N 0900025N7894ZPiper J3C-65 · S/N 15341First renewal noticeN8028EHouse S-12S · S/N 05030972N883ALSikorsky S-76C · S/N 760677N893BGKeystone Helicopter S-76C · S/N 760804N896BGKeystone Helicopter S-76C · S/N 760777N920VHSikorsky S-92A · S/N 920061N924PMCompagnie Daher TBM 700 · S/N 1482N941KWWaters Kenneth R CORBEN JUNIOR ACE · S/N 941N95791Taylorcraft BC12-D · S/N 8091N9906CSilvaire LUSCOMBE 8F · S/N S-9
Back to New Iberia, LA