Registered aircraft · 19

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:2002-01-30') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-30') 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:2002-01-30')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-30')
  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:2002-01-30')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-30')
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.

N114LAPike Mark D · Las Vegas, NVBuilt 1961 · S/N 1623 N119PHFordyce Joel · Gaston, ORS/N 2119 N148KWWeiland Keith E · Chandler, AZBuilt 1961 · S/N 1498 N174DBGulf Coast Helicopters Inc · Crowley, LABuilt 1961 · S/N 1593 N176DCCyclone Aviation LLC · Haymarket, VAS/N 1719 N208SJSan Juan Aviation LLC · Wilmington, DES/N 225245 N218SJSan Juan Aviation LLC · Wilmington, DES/N 2272/29 N225RWDufton Charles S · North Stonington, CTBuilt 1959 · S/N 1312 N265HAHigh Altitude Helicopters Inc · Brewster, WAS/N 2656 N31330Consummate Inc DBA · Cedar City, UTBuilt 1958 · S/N 1133 N313PHM&R Management Consulting Inc · Fort Meade, FLNon-citizen corporation, flight hours not reportedS/N 1694 N315CHFresh Heli LLC · Gillette, WYBuilt 1976 · S/N 2456 N316BJLama French Alps Inc Trustee · Wilmington, DEBuilt 1969 · S/N 1611 N316TXRosenberg Adrian · Laupahoehoe, HIS/N 2191 N4UHClassic Rotors Museum · Ramona, CAS/N 2279 N67081International Air Services Inc Trustee · Carson City, NVS/N 2184 N6UHClassic Rotors Museum · Ramona, CAS/N 1972 N8655Rosenburg Adrian · Laupahoehoe, HIBuilt 1970 · S/N 1728 N9ZJRain Air Helicopters LLC · Issaquah, WABuilt 1961 · S/N 1582

Back to AD 2002-01-30