Skip to content

Registered aircraft · 72,007

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

N356TBSky West Aviation Inc Trustee · Albuquerque, NMS/N 1709 N356VAVictory Aviation Club Inc · Hamilton, OHBuilt 1981 · S/N 32-8206008 N35700Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1968 · S/N 17256916 N35701Mcha Aviation LLC · Vinita, OKBuilt 1968 · S/N 17256917 N35705Paris Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-8016207 N35707Pray Aviation Inc · Augusta, KSBuilt 1968 · S/N 17256921 N3570EBlackbird Aviation Corp · Van Nuys, CAS/N 17271593 N35711Pumphrey Robert B Jr · Saint Paris, OHBuilt 1968 · S/N 17256925 N35712Mw Flying LLC · Sanford, NCBuilt 1968 · S/N 17256926 N3571335713 LLC · Kitty Hawk, NCBuilt 1968 · S/N 17256927 N35714Skyhawk Rising LLC · Manchester, IAFirst renewal noticeS/N 17256928 N35715Kindblade Aeronautics LLC · Casper, WYBuilt 1968 · S/N 17256929 N35716Ward Seth W · Demorest, GABuilt 1968 · S/N 17256930 N35718Parmerlee David · Grand Rapids, MIBuilt 1979 · S/N 32R-8013032 N35719Jensen Greg D · Omaha, NEBuilt 1968 · S/N 17256932 N3571GMid Continent Aircraft Corp · Hayti, MOBuilt 1964 · S/N 1080 N3571LPeltier Scott M · Longwood, FLS/N 28-8011071 N3571NCoker Steve L · Tyler, TXBuilt 1967 · S/N 680101 N3571PRegistration Pending · Myrtle Beach, SCRegistration pendingBuilt 1979 · S/N 28-8011069 N3571WJtw Financail Services · Norfolk, NEBuilt 1966 · S/N 32-463 N3571ZThompson Lyndon R · West Fargo, NDBuilt 1960 · S/N 18-7349 N35725Kling Jonathan N · Ruther Glen, VABuilt 1968 · S/N 17256936 N35726Jh Aero LLC · Little Rock, ARS/N 17256937 N35728Gone Broke LLC · Fairhope, ALBuilt 1968 · S/N 17256939 N3572BPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 32R-8013033 N3572GHauser Linda · Ulysses, KSBuilt 1964 · S/N 1081 N3572MPlane Nonsense Inc · Middletown, DEBuilt 1978 · S/N 28-7816356 N3572PMulkey Joshua D · Anchorage, AKS/N 18-4526 N3572QFloyd Richard C · Sutter Creek, CABuilt 1973 · S/N 17261676 N3572XKelsoe Gregory Lyle · Clermont, FLBuilt 1979 · S/N 28-8016213 N35730Miner Jay G · Seattle, WABuilt 1968 · S/N 17256940 N35731Registration Pending · Carthage, NCRegistration pendingBuilt 1968 · S/N 17256941 N35732Minney Andrew · Memphis, TNBuilt 1979 · S/N 28-8016195 N35735Gaston Brothers Excavating Inc · Seattle, WAS/N 17256943 N35738Plane Life LLC · Wilmington, DEBuilt 1968 · S/N 17256944 N3573GDuran Robert J · Fort Lupton, COBuilt 1964 · S/N 1082 N3573HBarnes Terry A · Austin, TXBuilt 1977 · S/N 20-1235 N3573PStewart James B · Anchorage, AKBuilt 1955 · S/N 18-4527 N3573QFly Lugu LLC · Westfield, MABuilt 1973 · S/N 17261677 N3573WRay Blake · Midland, TXBuilt 1966 · S/N 32-466 N3573ZBlue Ice Aviation Inc · Wasilla, AKBuilt 1960 · S/N 18-7359 N35741Covelli Scott · Spicewood, TXBuilt 1968 · S/N 17256945 N35744Noland Farms Inc · Blue Mound, ILBuilt 1968 · S/N 17256947 N35746Hoard David L · Germantown, TNBuilt 1968 · S/N 17256948 N35748Price Stanley C · Grapevine, TXBuilt 1968 · S/N 17256950 N35749Pashley John F · Johnstown, NYBuilt 1968 · S/N 17256951 N3574CAtd Pilot Training LLC · Kansas City, MOBuilt 1979 · S/N 28-8016200 N3574JI.F.C. Inc · Wayne, NEBuilt 1979 · S/N 28-8090196 N3574RGarner Financial Management Inc · Franklin, TNBuilt 1979 · S/N 32-7940287 N3574ZWestwood Dave · Red Lodge, MTBuilt 1960 · S/N 18-7360

Back to AD 87-10-06 R1