Registered aircraft · 18,495

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.

N732ZZDakota Aerial Ministries · Fargo, NDS/N 21061917 N7330HKibler Joseph T · Mount Airy, MDBuilt 1977 · S/N 18503365 N7331UBristol Bay Air Service Inc · Dillingham, AKBuilt 1977 · S/N 20700402 N7333VWeber Justin L · Temple, TXS/N 30190 N7334BKiesznowski Craig C · Romulus, MIBuilt 1954 · S/N D-3797 N7334NRobles James J · Oro Valley, AZBuilt 1976 · S/N U20603616 N7334PUp And Away Aviation LLC · Poughkeepsie, NYS/N P21000004 N7334VNelson Steven A · Intl Falls, MNBuilt 1969 · S/N 30212 N7336CDelta Kilo Av8 LLC · Bonita Springs, FLS/N 21063938 N7336HGerace William L · Anchorage, AKBuilt 1977 · S/N 18503366 N7336VHouten Peter Van · Paron, ARBuilt 1969 · S/N 30189 N7338VEiger Jet Support Group LLC · Manchester, NHBuilt 1969 · S/N 30230 N7339RDoell Tom C · Dallas, TXBuilt 1974 · S/N E-563 N733ACHock Frederick · Waynesboro, VABuilt 1974 · S/N CE-499 N733BYUnited States Air Force Owner · Colorado Springs, COBuilt 1965 · S/N TF-55 N733CDHerron Kevin · Checotah, OKFirst renewal noticeBuilt 2001 · S/N 0134 N733EHSherwood Aviation Consultants Inc · Redondo Beach, CABuilt 1978 · S/N U20604761 N733KDLake Clark Holdings LLC · Port Alsworth, AKBuilt 1978 · S/N U20604772 N733SEWaller Richard E · Marks, MSBuilt 1969 · S/N D-8919 N73408Shade Eric L · Dillingham, AKBuilt 1979 · S/N 20700586 N7340UYr-Aircraft Leasing LLC · Bethel, AKBuilt 1977 · S/N 20700407 N7340VRunnin Rabbit LLC · Kalispell, MTBuilt 1969 · S/N 30216 N7341CT Cole Holdings I LLC · Paint Rock, TXBuilt 1980 · S/N 21063939 N7343VStewart Bret A · Colleyville, TXBuilt 1969 · S/N 30203 N73467Ryan Air Inc · Anchorage, AKBuilt 1980 · S/N 20700594 N7346PIntegrated Avionics Services Inc · Hampstead, MDBuilt 1978 · S/N P21000007 N7346RSeagull Flying Club Inc · San Jose, CABuilt 1974 · S/N E-569 N7347NAv8 LLC · Boise, IDS/N U20603624 N7347RN145ta LLC · Carson City, NVBuilt 1974 · S/N TH-482 N7347VRazo Beltran Josefina · Carlton, ORBuilt 1969 · S/N 30209 N7348VAum Aero Aviation LLC · Kissimmee, FLBuilt 1969 · S/N 30200 N7349CMcbride Patrick J · Anchorage, AKBuilt 1977 · S/N U20603888 N7349RGettier Albert F Jr · Henderson, NVBuilt 1974 · S/N CE-507 N734CDJds Aviation LLC · San Mateo, CABuilt 2005 · S/N 1686 N734CXMount Crillon LLC · Juneau, AKBuilt 1978 · S/N U20604823 N734EJLavery Sam · Morgantown, WVBuilt 1978 · S/N U20604828 N734GWRwr Air Inc · Tok, AKBuilt 1978 · S/N U20604832 N734HBCalkins David M · Anchorage, AKBuilt 1973 · S/N 18502260 N734HW206 LLC · Portland, ORBuilt 1980 · S/N P21000602 N734HXWaters Aero- Marine Inc DBA · South Thomaston, MES/N U20604837 N734JCRegistered aircraftBuilt 1977 · S/N 21062107 N734PPKelley Jon B · Anchorage, AKBuilt 1979 · S/N U20604855 N734TMCorporate Air Service Inc · North Salt Lake, UTBuilt 1979 · S/N U20604870 N734VSVitatoe Industries Inc · Chillicothe, OHBuilt 1980 · S/N P21000614 N734WEMattie Joseph G · Ester, AKBuilt 1979 · S/N U20604883 N734WGStone Aviation LLC · Traverse City, MIBuilt 1980 · S/N P21000615 N734WHObermeyer Keith · Excelsior, MNBuilt 1980 · S/N P21000616 N734WXRegistration Pending · Kodiak, AKRegistration pending, pending cancellationBuilt 1979 · S/N U20604886 N73503Ryan Air Inc · Anchorage, AKBuilt 1980 · S/N 20700599 N7351UBlue Waves Holding One LLC · Miami, FLBuilt 1977 · S/N 20700415

Back to AD 86-13-04 R3