Registered aircraft · 19

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'KS' AND g.registrant_city = 'PRATT' ORDER BY g.n_number

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 = 'KS' AND g.registrant_city = 'PRATT'
  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 = 'KS' AND g.registrant_city = 'PRATT'
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.

N1030SStick & Rag Flying Club CB-1 · S/N 60Built 1979 · Livingston Daniel C N1697WBeech A36 · S/N E-365Built 1972 · Mountcastle Creek LLC N188KUDiamond Aircraft Ind DA 42 · S/N 42.AC020Built 2006 · Oak Street Properties LLC N217SYCirrus Design SR22T · S/N 1595Registration pendingBuilt 2017 N22831Piper J3C-65 · S/N 2752Livingston Daniel C N3649KDJI AGRAS T50 · S/N 1581F6BUB246J001S0C6Kanza Drone Services LLC N4589NCessna 340A · S/N 340A0556Built 1978 · Generic Implant Solutions LLC N518CDCirrus Design SR22 · S/N 1229Built 2004 · Cornerstone Auto Parts LLC N556CTBeech P35 · S/N D-7007Williamson Terry W Jr N5740JCessna 182P · S/N 18263509Built 1974 · Stonestreet Arlie D Trustee N5772VBeech A23-24 · S/N MA-24Southwest Truck Parts Inc N6537TPowrachute PC 2000 · S/N A016POWWilliamson Terry W N7298WPiper PA-28-180 · S/N 28-1151Schnitiker Allan A N76THawker Beechcraft G36 · S/N E-3901Built 2009 · Wapiti Holdings LLC N84880Aeronca 7AC · S/N 7AC-3599Built 1946 · Livingston Patrick A N89858Cessna 140 · S/N 8903Built 1946 · Livingston Patrick A N9261Dehavilland DHC-1 T.MK. 10 · S/N C1-0396Built 1951 · Pratt Air Inc N9277UCessna 150M · S/N 15078227Built 1976 · Peters Airway LLC N9436QBeech G33 · S/N CD-1276Built 1972 · Huitt Janet R

Back to Pratt, KS