Irving, TX
Registered aircraft · 60
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 = 'TX' AND g.registrant_city = 'IRVING' 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 = 'TX' AND g.registrant_city = 'IRVING' 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.
N1032DCessna 195A · S/N 7716N118NXMil Helicopters MI-24D · S/N 150153N1205TPiper PA-28-140 · S/N 28-7225422N120NXMil Helicopters MI-24D · S/N 110155N1415JRockwell International 112A · S/N 415Sale reportedN15169Piper PA-28R-200 · S/N 28R-7335032N159GDirect Fly S R O ALTO · S/N DFUS-16-022N204TSCessna TU206G · S/N U20604052N210TVBell 206L-3 · S/N 51267N21304Aeronca 65-C · S/N C-1098N213PZMil Moscow Helicopter MI-2 · S/N 515250087N21968Cessna 150L · S/N 15074576N2201QMooney M20J · S/N 24-0562N221TRCirrus Design SR20 · S/N 2659N253LPLazo Aitor RV-9A · S/N 92286N256TRCirrus Design SR20 · S/N 9818N257SDSagaert Ren MURPHY REBEL · S/N 319RN2626DCessna 170B · S/N 20778N2YCBeech 58 · S/N TH-487N3391FCessna 182J · S/N 18257391N362SBBeech A36 · S/N E-1848N369SARaytheon A36 · S/N E-3369N370CRMccracken TOADY T-4 · S/N T4N370RCessna U206G · S/N U20605501N39287Taylorcraft BC12-D · S/N 6541N397EGTextron 680A · S/N 680A0039N3MMCessna 525B · S/N 525B0451N403MCCessna LC41-550FG · S/N 411135N4481KRyan NAVION A · S/N NAV-4-1481N4651DCessna 172N · S/N 17272325N4827UCessna TU206G · S/N U20605119N4927LPiper PA-28-180 · S/N 28-4294N5006VSukhoi SU-25 K · S/N 25508105006N5040VSukhoi SU-25 K · S/N 25508105040N5186MTaylorcraft BC12-D · S/N 10486N599CTFlight Design CTLS · S/N F-11-10-06N604DHGulfstream Aerospace GVII-G500 · S/N 72057N618LRCessna T182T · S/N T18208829N625RRReece Robert R JR RV-8 · S/N 82551N6576NCessna 182R · S/N 18267839N672HGGulfstream Aerospace GVI (G650ER) · S/N 6519N678LRCirrus Design SF50 · S/N 0301N7304VBellanca 17-30 · S/N 30159N73298Cessna 172M · S/N 17267354N7432DPiper PA-22-150 · S/N 22-5195N74DHBombardier BD-700-1A11 · S/N 9217N7595RPiper PA-28-140 · S/N 28-22163N7859NPiper PA-28-180 · S/N 28-5317N79DHIai GULFSTREAM G280 · S/N 2213N800GYGreg Schroeder SPORTSMAN 2+2 · S/N 7155
Back to Irving, TX