Registered aircraft · 18,497

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-13-04-R3') 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-13-04-R3') 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-13-04-R3')
    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-13-04-R3')
  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-13-04-R3')
  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-13-04-R3')
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.

N206GRCopper River Airmotive LLC · Copper Center, AKBuilt 1972 · S/N U20601753 N206GTSmith Allen D · Hurricane, UTBuilt 1967 · S/N P206-0374 N206GVSawtooth Flying Service · Mccall, IDBuilt 1978 · S/N U20604833 N206HCHough Linwood L · Penn Yan, NYBuilt 1978 · S/N U20604356 N206HHSawtooth Flying Service Inc · Mccall, IDBuilt 1980 · S/N U20605675 N206JJ Bear Tours LLC · Homer, AKBuilt 1967 · S/N U2060965 N206JDZulu Flight LLC · Washougal, WABuilt 1968 · S/N P206-0536 N206JFReichert Kenneth J · Deer River, MNBuilt 1965 · S/N P206-0137 N206JJRuff Stephen D · Sandpoint, IDBuilt 1968 · S/N U206-1012 N206JL3 Tango 3 Flight LLC · Boyceville, WIFirst renewal noticeBuilt 1968 · S/N U2061091 N206JMSouthside Truck And Trailers Inc · San Antonio, TXBuilt 1973 · S/N U20602195 N206JVVercoe Jeffrey · Lincoln, MTBuilt 1968 · S/N P206-0556 N206JWMarley William Jay Jr · Homer, AKBuilt 1981 · S/N U20606283 N206KAir & Opportunity Aviation LLC · Austin, TXBuilt 1969 · S/N U206-1333 N206KDStubblefield Fancho F Jr Trustee · Amity, ORBuilt 1979 · S/N U20604981 N206KWCoyote Air LLC · Fairbanks, AKBuilt 1977 · S/N U20603762 N206KYWings Of Hope · Chesterfield, MOBuilt 1966 · S/N U206-0676 N206LFBoruch Joseph · Old Lyme, CTBuilt 1980 · S/N U20605436 N206MGIndependence Aviation Inc · La Porte City, IAS/N U20603910 N206MLFiedler Jean M · Sauk Centre, MNBuilt 1979 · S/N U20605253 N206MMHoistad Rick A · Forman, NDBuilt 1976 · S/N U20603318 N206NMoose Venutres LLC · Palo Alto, CABuilt 1977 · S/N U20603912 N206NMSug-Air LLC · Lubbock, TXS/N U20603132 N206PBHolland John R · Jacksonville, FLBuilt 1977 · S/N U20603781 N206PDRockwell Collins Inc · Cedar Rapids, IABuilt 1977 · S/N 676 N206PKCardinal Aviation LLC · Gaines, MIBuilt 1978 · S/N U20604341 N206PPElohim Airparts Sales LLC · Naples, FLBuilt 1965 · S/N U2060408 N206PYGreen Todd · Anchorage, AKBuilt 1975 · S/N U20602795 N206QVan Valin Scott E DBA · Craig, AKBuilt 1976 · S/N U20603259 N206RBFoster Steven W · Big Lake, AKBuilt 1968 · S/N U206-1068 N206RCPaloma Aviation LLC · Fruitland, IDBuilt 1974 · S/N U20602431 N206RHPure Sports Inc · Tavares, FLBuilt 1964 · S/N 206-0215 N206RKAlbrecq Robert W · Gardnerville, NVBuilt 1968 · S/N U206-1205 N206RTButler Bryan P · Monument, COBuilt 1977 · S/N U20603978 N206SDCampbell William P · Matador, TXBuilt 1964 · S/N P206-0053 N206SKLatschar Barry D · Oklahoma City, OKBuilt 1964 · S/N 206-0211 N206SNDye Seed Ranch Inc · Spokane Valley, WABuilt 1979 · S/N U20605101 N206SPHayden Scott · Anchorage, AKBuilt 1965 · S/N P206-0111 N206SUNorton Edward H · New York, NYBuilt 1976 · S/N U20603184 N206SVBremmer Randy R · Whitewater, COBuilt 1967 · S/N P206-0460 N206SXLaughlin Audio Video Electric Inc · Santa Ynez, CABuilt 1966 · S/N P206-0316 N206TDHomestead Helicopters Inc · Missoula, MTBuilt 1964 · S/N 206-0242 N206TMPale Horse LLC · Mishawaka, INBuilt 1975 · S/N E-775 N206TTThorson Thomas R · Wasilla, AKBuilt 1977 · S/N U20603772 N206TZTeton Leasing LLC · Polatello, IDBuilt 1979 · S/N U20605165 N206USKandle Douglas A · Boise, IDBuilt 1974 · S/N U20602628 N206VTSend North · Anchorage, AKBuilt 1967 · S/N U206-0993 N206WBOffice Of Aviation Services · Boise, IDBuilt 1973 · S/N U20602058 N206WDCritical 32 Degrees LLC · Milton Freewater, ORBuilt 1984 · S/N U20606832 N206WPMorrison Richard Lee Trustee · Anchorage, AKBuilt 1980 · S/N U20605897

Back to AD 86-13-04 R3