Azle, TX
Registered aircraft · 51
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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 = 'AZLE' 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 = 'AZLE' 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.
N108KJonker Sailplanes JS1C 18/21 · S/N 1C-117N111LSAmerican Champion 8KCAB · S/N 740-95N113SCPiper PA-19 · S/N 18-2003N1365LCessna 337H · S/N 33701857N1472EAeronca 7AC · S/N 7AC-5035N15064Piper PA-34-200 · S/N 34-7350005N1569YCessna 172C · S/N 17249269N1724RCessna R182 · S/N R18200536N187TWWright Kirk A RV7 · S/N 70643N21EMMooney M20J · S/N 243129N224GMMooney International M20TN · S/N 31-0137N224KACessna T210N · S/N 21063812N2549HEngineering & Research ERCOUPE 415-C · S/N 3174N260JFPiper PA-24-260 · S/N 24-4196N277SCChaney Shawn T ROTORWAY EXEC 162F · S/N 6832N277WSReims CESSNA F150M · S/N F15001406N284MAWatzlavick Robert L RV-10 · S/N 42284N3320CBeech E35 · S/N D-3986N336ADCessna 336 · S/N 336-0054N3392HErcoupe 415-D · S/N 4017N341HHEurocopter France SA 341G · S/N 1099Registration pendingN3451FCessna 182J · S/N 18257451N3556MPiper PA-12 · S/N 12-2501N3782Grier FLY BABY 1A · S/N 67-24N4323CBracken William D GLASTAR · S/N 5584N450HSBoeing E75 · S/N 75-3876N456LLCirrus Design SR22 · S/N 3009N5047GBellanca 7ECA · S/N 1302-79N50BZCirrus Design SR20 · S/N 1327N515SPiper PA-24-250 · S/N 24-3609Registration pending, pending cancellationN53420Cessna 337G · S/N 33701613N541CAPiper PA-28-181 · S/N 28-7790089N55355Boeing A75 · S/N 75-198N567JLBeech 95-B55 · S/N TC-1718N571SAAmerican Champion 8KCAB · S/N 1009-2005Registration pendingN66751Cessna 150M · S/N 15076251N67329Cessna 152 · S/N 15281758N6770NMooney M-20G · S/N 680090N69NNSchweizer TH55A/269A · S/N 67-16846N6LHCessna 421B · S/N 421B0227N70197Powrachute PEGASUS · S/N A-074PEGN72588Beech B95A · S/N TD-532N759UCCessna 182Q · S/N 18266261N7688Piper PA 46-350P · S/N 4636055N86306Cessna 337D · S/N 337-1148N8787QCessna U206G · S/N U20603539N887TTTimothy A Talmage MIDGET MUSTANG · S/N M-1-1593N89648Cessna 152 · S/N 15282816N89RBBarden THORP T-18 · S/N 895N92114Cessna 182M · S/N 18260050
Back to Azle, TX