Registered aircraft · 30

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

N117TGInternational Air Response Inc · Coolidge, AZBuilt 1954 · S/N 54-1631 N118TGInternational Air Response Inc · Coolidge, AZBuilt 1957 · S/N 57-0512 N120TGInternational Air Response Inc · Coolidge, AZBuilt 1955 · S/N 3035 N121TGInternational Air Response · Coolidge, AZBuilt 1956 · S/N 56-0511 N130CGCoulson Aviation USA Inc · Portland, ORBuilt 1969 · S/N 382-4339 N131ECPacific Aircraft Services LLC · Saint Helens, ORS/N 3212 N132CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1968 · S/N 382-4338 N133FFB&G Industries LLC · Greybull, WYS/N 56-535 N136CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1969 · S/N 382-4334 N140CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1969 · S/N 382-4337 N234HGAviation & Defense Inc · Calabasas, CAS/N 382-4211 N382CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1969 · S/N 382-4336 N382HTCardinal Services Corp · Kalispell, MTS/N 5032 N404LCAirplane Sales International Corp · Sherman Oaks, CABuilt 1977 · S/N 4763 N4053LCoulson Aviation (USA) Inc · Portland, ORS/N 382-4053 N4054Coulson Aviation (USA) Inc · Portland, ORS/N 382-4054 N405LCLynden Air Cargo LLC · Anchorage, AKBuilt 1985 · S/N 5025 N407LCLynden Air Cargo LLC · Anchorage, AKBuilt 1991 · S/N 5225 N408LCLynden Air Cargo LLC · Anchorage, AKBuilt 1975 · S/N 4600 N4312LCoulson Aviation (USA) Inc · Portland, ORS/N 382-4312 N4313LCoulson Aviation (USA) Inc · Portland, ORS/N 382-4313 N460DFCalifornia Dept Of Forestry And Fire Protection · Mcclellan, CAS/N 4996 N462DFCalifornia Dept Of Forestry And Fire Protection · Mcclellan, CAS/N 5034 N464DFCalifornia Dept Of Forestry And Fire Protection · Mcclellan, CAS/N 5002 N465DFCalifornia Dept Of Forestry And Fire Protection · Mcclellan, CAS/N 5035 N466TMT B M Inc · Atwater, CABuilt 1957 · S/N 57-466 N468DFCalifornia Dept Of Forestry And Fire Protection · Mcclellan, CAS/N 5107 N479TMTbm Inc · Atwater, CAS/N 57-0479 N531TBTbm · Atwater, CAS/N 56-0531 N567DFCalifornia Dept Of Forestry And Fire Protection · Mcclellan, CAS/N 5005

Back to AD 2023-09-13