Skip to content

American Patrols Inc

Registered aircraft · 65

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

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_name = 'AMERICAN PATROLS INC' OR list_contains(g.other_registrant_names, 'AMERICAN PATROLS INC') 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_name = 'AMERICAN PATROLS INC' OR list_contains(g.other_registrant_names, 'AMERICAN PATROLS INC')
  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_name = 'AMERICAN PATROLS INC' OR list_contains(g.other_registrant_names, 'AMERICAN PATROLS INC')
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.

N12456Cessna 172M · S/N 17261994Built 1973 · Midland, TX N12698Cessna 172M · S/N 17262187Built 1973 · Midland, TX N12783Cessna 172M · S/N 17262256Built 1973 · Midland, TX N12901Cessna 172M · S/N 17262356Built 1973 · Midland, TX N12955Cessna 172M · S/N 17262400Built 1973 · Midland, TX N133AJCessna 172P · S/N 17276614Built 1986 · Midland, TX N13683Cessna 172M · S/N 17262940Built 1974 · Midland, TX N13692Cessna 172M · S/N 17262946Built 1974 · Midland, TX N1546VCessna 172M · S/N 17263654Built 1974 · Midland, TX N1774VCessna 172M · S/N 17263747Built 1974 · Midland, TX N19803Cessna 172M · S/N 17260766Built 1972 · Midland, TX N20208Cessna 172M · S/N 17261096Built 1972 · Midland, TX N20341Cessna 172M · S/N 17261204Built 1972 · Midland, TX N20823Cessna 172M · S/N 17263848Built 1974 · Midland, TX N24155Cessna 172P · S/N 17275290Built 1981 · Midland, TX N241RGCessna 172M · S/N 17261916Built 1973 · Midland, TX N2720ECessna 172N · S/N 17271305Built 1978 · Midland, TX N27GFCessna 172P · S/N 17274608Built 1981 · Midland, TX N2895QCessna 172L · S/N 17259895Built 1971 · Midland, TX N323SMCessna 172L · S/N 17260679Built 1972 · Midland, TX N3803QCessna 172L · S/N 17259903Built 1971 · Midland, TX N3865QCessna 172L · S/N 17259965Built 1971 · Midland, TX N4384RCessna 172M · S/N 17263134Built 1974 · Midland, TX N46655Cessna 172K · S/N 17257413Built 1968 · Midland, TX N52473Cessna 172P · S/N 17274535Built 1980 · Midland, TX N5253RCessna 172M · S/N 17263467Built 1974 · Midland, TX N5366KCessna 172P · S/N 17274084Built 1980 · Midland, TX N53822Cessna 172P · S/N 17274821Built 1981 · Midland, TX N5383KCessna 172P · S/N 17274088Built 1980 · Midland, TX N5480KCessna 172P · S/N 17274146Built 1980 · Midland, TX N55374Cessna 172P · S/N 17275170Built 1981 · Midland, TX N612HPCessna 172P · S/N 17274933Built 1981 · Midland, TX N61672Cessna 172M · S/N 17264719Built 1975 · Midland, TX N62694Cessna 172P · S/N 17275327Built 1981 · Midland, TX N62876Cessna 172P · S/N 17275346Midland, TX N63681Cessna 172P · S/N 17275467Built 1981 · Midland, TX N64219Cessna 172M · S/N 17265098Built 1975 · Midland, TX N64542Cessna 172M · S/N 17265296Built 1975 · Midland, TX N64736Cessna 172P · S/N 17275615Built 1982 · Midland, TX N6545HCessna 172M · S/N 17265483Built 1975 · Midland, TX N65614Cessna 172P · S/N 17275785Built 1982 · Midland, TX N65758Cessna 172P · S/N 17275862Built 1982 · Midland, TX N6ZPCessna 172P · S/N 17274020Built 1980 · Midland, TX N7082QCessna 172L · S/N 17260382Built 1972 · Midland, TX N7128QCessna 172L · S/N 17260428Built 1972 · Midland, TX N7156QCessna 172L · S/N 17260456Built 1972 · Midland, TX N725BKCessna 172L · S/N 17259821Built 1971 · Midland, TX N73172Cessna 172M · S/N 17267299Built 1976 · Midland, TX N738CYCessna 172N · S/N 17269883Built 1977 · Midland, TX N747VHCessna 172M · S/N 17266914Built 1976 · Midland, TX

Back to American Patrols Inc