Edgewood, TX
Registered aircraft · 42
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 = 'EDGEWOOD' 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 = 'EDGEWOOD' 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.
N106LHKowalewski William Paul KOWALEWSKI ZERO FITR · S/N 001N110TXHackney Donald P VANS RV-7 · S/N 70707N1153QMooney M20J · S/N 24-1240N1177FCessna 172G · S/N 17254772N124KACessna 177B · S/N 17702181N150SRProgressive Aerodyne SEAREY LSA · S/N 1054N179DAviat A-1C-180 · S/N 3175N17BKKing Brandon S7 STI · S/N KA22080540N197WBProgressive Aerodyne SEAREY LSA · S/N 1091N214KTPaine Lauran JR RV-8 · S/N 80780N2646KPiper J3C-65 · S/N 22335N2876FCessna 182J · S/N 18256976N315SQAudet Alfred VANS RV-4 · S/N 675N32VMMichael J Stone MTO SPORT · S/N M00961N333FHBeech 95-B55 · S/N TC1934N342MMooney M-18C · S/N 222N345PRNeuberg Bill GLASTAR · S/N 5724N35850Cessna 177RG · S/N 177RG1061N3618PPowrachute AIRWOLF 912ULS · S/N A450ULSN375SHumphreys Richard D HUMPHREYS SKYBOLT · S/N 1N413WCClark Wayne CLARK RV 9 · S/N 91607N5107VMorrisey 2150 · S/N FP-7N519KWKenneth D White SKYREACH BUSHCAT · S/N CH159BN524TXRathburn Robert L VANS RV-14A · S/N 141034N5549JPiper PA-32-260 · S/N 32-1011N558PCPiper PA-24 · S/N 24-333N584BRRathburn Robert L VANS RV8A · S/N 82948N610AFAbid Farooqui AR-1 · S/N 0050N64099Cessna 180K · S/N 18052870N668BCAmerican Champion 8GCBC · S/N 570-2015N7252TBeech A36 · S/N E-2261N730KPSchumacher Joe VANS RV-7 · S/N 71268N75YACessna 210E · S/N 21058665N7786RBeech V35A · S/N D-8884N781SFCharles T Smith TR-4 · S/N 4021N8080RBeech V35A · S/N D-8993N8243YPiper PA-30 · S/N 30-1369N8609ZSouthern Power Parachute CONDOR · S/N 067N86UMMooney M20E · S/N 1137N925ZAPowrachute AIRWOLF 912ULS · S/N A377ULSN986XGrumman G-164A · S/N 662N999TBeech P35 · S/N D7210
Back to Edgewood, TX