Registered aircraft · 22

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:2007-10-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:2007-10-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:2007-10-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:2007-10-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:2007-10-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:2007-10-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.

N10MUMorgan Daniel R · Salem, INS/N 201 N10WYCarraway Terry Jr · Aberdeen, MDBuilt 1983 · S/N 187 N139BKInternational Air Service Inc Trustee · Carson City, NVBuilt 1981 · S/N 139 N140JAWhitney Lydia Mae · North Charleston, SCBuilt 1982 · S/N 140 N1414TThomas Evan C · Lancaster, CABuilt 1985 · S/N 206 N151NAMht Aviation LLC · Saint Petersburg, FLBuilt 1984 · S/N 197 N227AMInternational Air Services Inc Trustee · Carson City, NVBuilt 1990 · S/N 249 N38DHOdi Aviation Services LLC · Kearneysville, WVBuilt 1981 · S/N 132 N40JVWhiting Andrew W · Mentor, OHBuilt 1977 · S/N 80 N4237SSpencer William D · Martinsville, VAS/N EPC-154 N4238CSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1965 · S/N EPC-155 N4238XHoughton Peter J · Eugene, ORS/N EPC-157 N42396Lawrence Jack C Jr · Saint Augustine, FLBuilt 1990 · S/N EPC-161 N42415Barron Texas Holdings LLC · Sheridan, WYS/N EPC-162 N4247SBrogden Aviation LLC · Olathe, KSBuilt 1982 · S/N EPC-170 N4249RWilloughey Jim L · Lawton, OKS/N EPC-172 N44BWMariani Aviation Services LLC · Vero Beach, FLBuilt 1987 · S/N 219 N503DWInternational Air Services Inc Trustee · Carson City, NVS/N 202 N780SN780s LLC · Williamstown, NJBuilt 1978 · S/N 87 N80MCTj Air Holdings Inc Trustee · Wilmington, DES/N 221 N82DMSale Reported · Marstons Mills, MASale reported, pending cancellationBuilt 1978 · S/N 88 N99KBKeller Bros Airport Inc · Lebanon, PABuilt 1990 · S/N 229

Back to AD 2007-10-13