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:2001-26-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:2001-26-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:2001-26-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:2001-26-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:2001-26-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:2001-26-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.

N101PCSomers Charles · Hillsboro, ORBuilt 1978 · S/N 101 N1NGLewis Aeronautical LLC · San Antonio, TXBuilt 1999 · S/N 614 N517GMSpitfire Aviation LLC · Scottsdale, AZBuilt 1982 · S/N 395 N519AHComanche Maverick Air LLC · Houston, TXBuilt 1987 · S/N 519 N548MBSomers Charles · Hillsboro, ORBuilt 1988 · S/N 548 N60LTEastern Stearman Inc Trustee · Leesburg, VAS/N 615 N618SLewis Aeronautical LLC · San Antonio, TXS/N 618 N66PNSomers Charles · Hillsboro, ORS/N 617 N6ATMayer Jon R · Reno, NVS/N 447 N717LETentacle Corp · Walnut Creek, CABuilt 1988 · S/N 549 N76XCHangar C-403 LLC · Walnut Creek, CABuilt 1985 · S/N 485 N795MKSouthern Palms Leasing LLC · Sarasota, FLBuilt 1985 · S/N 487 N807JHClark Joseph · Seattle, WABuilt 1985 · S/N 498 N816BPAls Aviation LLC · Westlake Village, CABuilt 1985 · S/N 480 N828PCSbma Services LLC · Mcclellan, CAS/N 479 N870A & S Aviation LLC · Chesterfield, MOBuilt 1993 · S/N 607 N901AKA C Sunni LLC · Santa Monica, CABuilt 2000 · S/N 616 N902AKDillon Aero Inc · Phoenix, AZBuilt 1988 · S/N 560 N98VKFb Aviation Services LLC · Wilmington, DEBuilt 1989 · S/N 559

Back to AD 2001-26-13