Registered aircraft · 23

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

N144PLCatskill Transportation LLC · Kingston, NYBuilt 1984 · S/N 42-5527014 N158MHMansfield Heliflight Inc · Milton, VTS/N 42-5527006 N321LHMullins Michael · Seaford, DEBuilt 1985 · S/N 42-5527012 N332SAPharmair LLC · Jackson, MSBuilt 1985 · S/N 42-5527025 N370AB4 Boys Air LLC · Rockwall, TXBuilt 1984 · S/N 425527008 N37KWBroco Viii LLC · Tipton, INBuilt 1989 · S/N 425527039 N3SPAvon Aero Supply Inc · Orlando, FLBuilt 1984 · S/N 42-5527018 N400ELEmmair LLC · Greenbrier, ARBuilt 1989 · S/N 42-5527041 N400LRKelly Aero LLC · Montgomery, ALBuilt 1984 · S/N 42-5527003 N400PBPlane Easy LLC · Lake Worth, FLBuilt 1984 · S/N 425527005 N400VBKelleher Corporation · San Rafael, CABuilt 1985 · S/N 42-5527002 N411BGSeas To See LLC · Nacogdoches, TXBuilt 1984 · S/N 42-5527004 N448CASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 425527034 N450MWValiair Ltd Co Trustee · Casper, WYS/N 42-5527013 N46HLGsp Air LLC · Sparta, NJBuilt 1985 · S/N 42-5527017 N47ZGJep Air LLC · Jackson, WYBuilt 1985 · S/N 42-5527031 N486MTNavy 8686 LLC · Boston, MABuilt 1985 · S/N 425527029 N500LMLets Fly Somewhere LLC · Canyon, TXBuilt 1984 · S/N 42-5527016 N508PMTvc Av LLC · Jacksonville, FLBuilt 1984 · S/N 42-5527021 N57VEN64fd LLC · Wilmington, DES/N 42-5527027 N7222FGriffin Aviation LLC · Great Falls, VABuilt 1987 · S/N 42-5527036 N92EVAirborne Resources Inc · Midlothian, TXBuilt 1987 · S/N 425527035 N93PPEmmair LLC · Greenbrier, ARS/N 425527022

Back to AD 86-18-10