Germantown, TN
Registered aircraft · 79
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 = 'TN' AND g.registrant_city = 'GERMANTOWN' 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 = 'TN' AND g.registrant_city = 'GERMANTOWN' 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.
N117RVBoeing B75N1 · S/N 75-7232N122JCChestnut Bruce J CHRISTEN EAGLE II · S/N 0001-183N12DYYoung Daniel R PITTS MODEL 12 · S/N 095N12PScherrer STARDUSTER TWO · S/N 001N15898Rearwin 8500 · S/N 478N1713MCessna 337E · S/N 33701313N1947PPiper PA-22-150 · S/N 22-2698N20SBBellanca 7GCBC · S/N 917-76N2155RCessna 182G · S/N 18255355N2359RCessna 182G · S/N 18255459N2419YCessna 172D · S/N 17249719N2442TNavion NAVION G · S/N NAV-4-2442N272RSRonald Simkin M24 ORION PLUS · S/N 24234336N2852WBeech 58 · S/N TH-349N28ERCessna 182K · S/N 18257645N28RAPiper PA-28-140 · S/N 28-20510N30767Cessna 177B · S/N 17701453N333BZBeech 35-B33 · S/N CD-416N3364LCessna 310Q · S/N 310Q0784N33YYPiper PA-28-180 · S/N 28-3230N3407SCessna 182G · S/N 18255807N35746Cessna 172I · S/N 17256948N361BSN961bs CCX-2000 · S/N CCX-2000-0153N3690KPiper PA-28-140 · S/N 28-23689N36ZMPilatus PC-12/47E · S/N 1640N3805EBeech C90 · S/N LJ-943N417ESCessna 182S · S/N 18280082N41SBBeech S35 · S/N D-7608N4280SBeech V35B · S/N D-9969N4331HPiper PA-17 · S/N 15-118N4455BBeech 95-B55 (T42A) · S/N TC-2203N454HHowle Donald B RV-14A · S/N 140735N45MJPiper PA-31-325 · S/N 31-7912104N469NLRobinson Helicopter R22 BETA · S/N 1911N48WDDavis William R JR RV-8 · S/N 80681N50WLBeech 35-B33 · S/N CD-661N51209Cessna 150J · S/N 15069840N519JHHalbert James H VENTERRA S-19 · S/N 060800010N5209GCessna 305A · S/N 21811N527HECirrus Design SF50 · S/N 0468N52986Howard DGA-15P · S/N 988N53APiper PA-20-135 · S/N 20-926N557HPCessna 525 · S/N 525-0668N567HEEpic E1000 · S/N K122N5834HPiper PA-16 · S/N 16-453N59BEBeech K35 · S/N D-6118N59EFCessna 182T · S/N 18281359N600RJPiper PA-23-250 · S/N 27-7954114N602PBeech D50B · S/N DH-224N6076WPiper PA-28-140 · S/N 28-20089
Back to Germantown, TN