Skip to content

Registered aircraft · 53

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-19-17') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-19-17') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-19-17')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-19-17')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-19-17')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-19-17')
ORDER BY 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.

N1043TCroman Corp · White City, ORBuilt 1961 · S/N 61083 N1048YCroman Corp · White City, ORBuilt 1961 · S/N 61161 N161CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1968 · S/N 61363 N168CHColumbia Helicopters Inc · Aurora, ORBuilt 1965 · S/N 408 N185CHBank Of Utah Trustee · Salt Lake City, UTBuilt 1963 · S/N 104 N188CHColumbia Helicopters Inc · Aurora, ORBuilt 1964 · S/N 107 N189CHColumbia Helicopters Inc · Aurora, ORBuilt 1964 · S/N 108 N190CHColumbia Helicopters Inc · Aurora, ORBuilt 1962 · S/N 2002 N191CHColumbia Helicopters Inc · Aurora, ORBuilt 1962 · S/N 2003 N192CHColumbia Helicopters Inc · Aurora, ORBuilt 1967 · S/N 4011 N261CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1985 · S/N 61257 N3173USiller Helicopters LLC · Chamblee, GABuilt 1963 · S/N 61186 N408FSCroman Corp · White City, ORBuilt 1966 · S/N 61361 N408UDCroman Corp · White City, ORBuilt 1974 · S/N 61772 N408WCCroman Corp · White City, ORBuilt 1977 · S/N 61764 N410GHCroman Corp · White City, ORBuilt 1975 · S/N 61749 N4263ACroman Corp · White City, ORBuilt 1966 · S/N 61551 N448JSBank Of Utah Trustee · Salt Lake City, UTBuilt 1968 · S/N 61428 N45917Siller Helicopters LLC · Chamblee, GABuilt 1965 · S/N 61271 N476AWConstruction Helicopters LLC · Howell, MIBuilt 1971 · S/N 61476 N5193YAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1963 · S/N 61-184 N614CKCroman Corp · White City, ORBuilt 1974 · S/N 61715 N617CKCroman Corp · White City, ORBuilt 1962 · S/N 61164 N618CKCroman Corp · White City, ORS/N 61454 N61NHCroman Corp · White City, ORBuilt 1970 · S/N 61474 N61NWUS Leaseco Inc · Aurora, ORBuilt 1974 · S/N 61719 N623CKCroman Corp · White City, ORBuilt 1977 · S/N 61762 N624CKCroman Corp · White City, ORBuilt 1964 · S/N 61272 N625CKCroman Corp · White City, ORBuilt 1963 · S/N 61-216 N626CKCroman Corp · White City, ORBuilt 1963 · S/N 61220 N627CKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 61824 N629CKCroman Corp · White City, ORBuilt 1975 · S/N 61751 N6674DColumbia Helicopters Inc · Aurora, ORBuilt 1962 · S/N 4 N6675DColumbia Helicopters Inc · Aurora, ORBuilt 1962 · S/N 5 N6682DColumbia Helicopters Inc · Aurora, ORBuilt 1964 · S/N 101 N712HGConstruction Helicopters LLC · Howell, MIBuilt 1973 · S/N 61712 N760HTU S Leaseco Inc · Aurora, ORBuilt 1978 · S/N 61811 N761HGConstruction Helicopters LLC · Howell, MIBuilt 1977 · S/N 61761 N762HTUS Leaseco Inc · Aurora, ORBuilt 1976 · S/N 61755 N765AWCroman Corp · White City, ORBuilt 1976 · S/N 61765 N773WCIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1978 · S/N 61807 N775HGConstruction Helicopters LLC · Howell, MIBuilt 1977 · S/N 61775 N804ARCroman Corp · White City, ORBuilt 1964 · S/N 61222 N825WLHeligroup Fire LLC · Missoula, MTBuilt 1980 · S/N 61825 N826WCConstruction Helicopters LLC · Howell, MIBuilt 1980 · S/N 61826 N827HGConstruction Helicopters LLC · Howell, MIBuilt 1980 · S/N 61827 N833ARCroman Corp · White City, ORBuilt 1974 · S/N 61738 N904CHConstruction Helicopters LLC · Howell, MIBuilt 1977 · S/N 61777 N906CHConstruction Helicopters LLC · Howell, MIBuilt 1971 · S/N 61490 N907CHHeligroup Fire LLC · Missoula, MTBuilt 1979 · S/N 61819

Back to AD 97-19-17