Registered aircraft · 2,552

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

N5400APittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1957 · S/N 35600 N5406AJanke Merle D II · Simi Valley, CABuilt 1957 · S/N 35606 N5412ABlue Skies Aircraft LLC · Kalispell, MTS/N 35612 N5418ATyler James · Oklahoma City, OKBuilt 1957 · S/N 35618 N541CMAero Parts LLC · Roselle, ILS/N 340-0338 N541DWJanssen Donald D · Mesa, AZBuilt 1960 · S/N 310-0021 N5432MWorthington Loren D · Caldwell, IDBuilt 1972 · S/N 340-0033 N5435AAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1958 · S/N 35635 N543BCRoeloffs Arie · Wendell, IDBuilt 1973 · S/N 414-0474 N543MPayne Jon R · Danville, PABuilt 1961 · S/N 320-0030 N5443JKg&C Investment LLC · Saint Charles, ILBuilt 1975 · S/N 421B0901 N5448JInfinity Aviators LLC · Scottsdale, AZBuilt 1975 · S/N 421B0906 N544RAnderson Daniel R · Venus, TXBuilt 1960 · S/N 39210 N5459ABaginski D Dianne Marie · Salesville, OHBuilt 1958 · S/N 35659 N5461AYaeger Edwin R · Stoneville, NCBuilt 1958 · S/N 35661 N5461JGlyn Dwr Aviation LLC · Kalispell, MTS/N 310R0259 N5473ABoisseau Guy M · Gulf Breeze, FLBuilt 1958 · S/N 35673 N5474JRedick Albert L II · Reno, NVBuilt 1975 · S/N 310R0272 N5479JBluegoose Aviation LLC · Muscle Shoals, ALBuilt 1975 · S/N 310R0277 N5482AMapel Steven L · May, TXBuilt 1958 · S/N 35682 N5484JCaba Joseph · Covington, LAS/N 310R0282 N5488JGrace Aviation LLC · Rogers, ARBuilt 1975 · S/N 310R0286 N5490JCullen Clay T · Danbury, CTS/N 310R0288 N5495JMesquite Express LLC · Waco, TXBuilt 1975 · S/N 310R0293 N54DFSkywave Associates LLC · Spirit Lake, IABuilt 1972 · S/N 340-0172 N550BRF P And P I Enterprises Inc · Oceanside, CABuilt 1974 · S/N 414-0533 N550FSRegistration Pending · Sheboygan Falls, WIRegistration pendingBuilt 1968 · S/N 401-0289 N552SSky'S The Limit Aviation LLC · Wilmington, DES/N 340-0170 N5555QPeterson Randall · Lake Havasu City, AZBuilt 1959 · S/N 35994 N555JDMike Bravo LLC · Chicago, ILBuilt 1979 · S/N 310R1629 N555MVDavis Elijah L · West Union, OHBuilt 1966 · S/N 310K0186 N555MYSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 421B0886 N555RFRayburn Aviation LLC · Center, TXBuilt 1974 · S/N 421B0621 N555TYKiefer Karl F · Spring, TXBuilt 1974 · S/N 340-0515 N558BTKeesling Roger L · Starkville, MSBuilt 1969 · S/N 310P0220 N55ABAllan Michael D · Forney, TXBuilt 1974 · S/N 310R0038 N55BFrankel Cary S · Harrison, NYBuilt 1979 · S/N 310R1830 N55CMCamille Ventures LLC · Odessa, TXBuilt 1973 · S/N 4140423 N55DKUrbina Mario Antonio · Pacoima, CABuilt 1959 · S/N 35878 N55LTRegistration Pending · Tucson, AZRegistration pendingS/N 414-0926 N55PPChaffey Community College District · Rancho Cucamonga, CABuilt 1972 · S/N 414-0366 N566AGarrett Flying Service Inc · Danbury, TXBuilt 1965 · S/N 320D0062 N567Herr John Robert · Saint Petersburg, FLFirst renewal noticeBuilt 1972 · S/N 310Q0459 N567CWPlane Fun Inc Tr Trustee · Snellville, GAS/N 0076 N56CMFamily Practice Associates LLC · Ulysses, KSS/N 310R1422 N56HDouble D International LLC · Miami, FLBuilt 1977 · S/N 414-0941 N56VPGoulette Bryan · Fort Worth, TXBuilt 1961 · S/N 320-0036 N5701MConsulat Inc · Cheyenne, WYS/N 310P-0001 N5701XCoan Mark A · Berthoud, COBuilt 1961 · S/N 320-0001 N5709MClear Blue Western Sky LLC · Anthem, AZBuilt 1968 · S/N 310P-0009

Back to AD 76-08-02 R2