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.

N7355CGeneva Laes Aviation LLC · Lake Geneva, WIBuilt 1973 · S/N TE-925 N7355VLadner Donald E Jr · Centerville, TXS/N 30213 N7356VRegistration Pending · Kalispell, MTRegistration pendingBuilt 1969 · S/N 30192 N7357CPerson Donna Mae · Columbus, NEBuilt 1980 · S/N 21063945 N7357RWalter Charles T Jr · Ocala, FLBuilt 1974 · S/N E-571 N7358BHinkle Aviation LLC · Moro, ARS/N TH-373 N7359CAhlem Charles D · Hilmar, CABuilt 1977 · S/N U20603897 N7359VHatheway Justin C · Hot Springs, SDBuilt 1969 · S/N 30199 N735AXState Of North Carolina · Raleigh, NCBuilt 1985 · S/N 18504439 N735BTPtmm LLC · Columbus, OHBuilt 1979 · S/N U20604898 N735CEKangas Randy P · Fairbanks, AKS/N U20604899 N735DNState Of North Carolina · Raleigh, NCBuilt 1985 · S/N 185-04441 N735EACivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 18504442 N735EDState Of North Carolina · Morehead City, NCBuilt 1985 · S/N 185-04443 N735EKState Of North Carolina · Raleigh, NCBuilt 1985 · S/N 185-04444 N735HBPierson Bradley A · Anchor Point, AKBuilt 1985 · S/N 18504448 N735JTStationair 6 LLC · Corinth, MSBuilt 1979 · S/N U20604930 N735LSPatrick Andrew · Boise, IDBuilt 1979 · S/N U20604937 N735MPHelms Aviation Inc · Long Lake, NYBuilt 1979 · S/N U20604940 N735MWWaddell Byron · Henderson, NVBuilt 1979 · S/N U20604942 N735MYVanderpool Robert W · Red Devil, AKBuilt 1979 · S/N U20604943 N735PTwo J Aviation LLC · Lima, OHBuilt 1978 · S/N TH-981 N735QPCulver Marc D · Anchorage, AKBuilt 1979 · S/N U20604952 N735VThomas Stephen · Granbury, TXBuilt 1979 · S/N D-10262 N735XVGps Land Company LLC · Brandon, MSBuilt 1979 · S/N U20604980 N73612American Aviation Inc · Page, AZBuilt 1980 · S/N 20700608 N7361CFocused Holdings LLC · Wellsville, UTS/N U20603899 N7363VHillier Layne J · Billings, MTBuilt 1969 · S/N 30222 N73663Summit Lake Aviation Inc · Olympia, WABuilt 1980 · S/N 20700612 N7366RAndes David A · Fairborn, OHBuilt 1974 · S/N CE-514 N7367CRuebling Edward X · Anchorage, AKBuilt 1977 · S/N U20603905 N7367RMockingbird Aviation LLC · Wilmington, NCBuilt 1974 · S/N D-9638 N7368RCruiseair Aviation Inc · Ramona, CABuilt 1974 · S/N CE-510 N7368VSellars Dean E · Sheridan, WYBuilt 1969 · S/N 30229 N7369RDuman Ralph J · Cedarville, MIBuilt 1974 · S/N D-9650 N7371VMullins Michael W · Marshall, TXBuilt 1969 · S/N 30228 N73727Redtail Partners LLC · Moab, UTBuilt 1980 · S/N 20700617 N7372HLindholm Michael D · Anchorage, AKBuilt 1977 · S/N 18503378 N73733Muffett Pat D · Eastsound, WABuilt 1980 · S/N 20700618 N7373UYr-Aircraft Leasing LLC · Bethel, AKBuilt 1977 · S/N 20700423 N7373VHannah Lonnie · Williamson, WVBuilt 1979 · S/N 79-30934 N73742Adams Bruce M · Santa Fe, NMBuilt 1980 · S/N 20700619 N7375NEllison Air Inc · Anchorage, AKS/N U20603641 N7377HProcaccini Donald Jr · Spring Hill, FLBuilt 1977 · S/N 18503382 N73789Ryan Air Inc · Anchorage, AKBuilt 1980 · S/N 20700629 N7378RLarson Aviation LLC · Waukegan, ILBuilt 1974 · S/N CE-516 N7379RSunny Skies Inc · Columbus, GABuilt 1974 · S/N TH-512 N7379UIliamna Air Taxi Inc · Iliamna, AKBuilt 1978 · S/N 20700427 N7379VPainter Lucia C · Yuba City, CABuilt 1969 · S/N 30205 N737DMAbove & Beyond Aviation Inc · Anchorage, AKBuilt 1977 · S/N 18503307

Back to AD 86-13-04 R3