OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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

N957MM957mm Inc · Wilmington, DEBuilt 1964 · S/N TC-669N9580RHershberger Daniel S · Bedford, INBuilt 1959 · S/N D-6178N9582RP F M Aviation Inc · Toledo, OHBuilt 1959 · S/N D-6138N9582YCastlewood Medical LLC · Dallas, TXBuilt 1962 · S/N TC-359N9583QHangarfinds LLC · Westminster, COBuilt 1966 · S/N D-8211N9583RVtaildoc LLC · Venice, FLBuilt 1959 · S/N D-6180N9583YMiller Cody J · Willmar, MNBuilt 1962 · S/N D-7043N9584RDdgs LLC · Nashville, TNBuilt 1959 · S/N D-6139N9585QTarheel Aircraft Inc · Richlands, NCBuilt 1968 · S/N D-8828N9586RCarter James L · Mesa, AZBuilt 1959 · S/N D-6182N9587QCherokee Flyers Lc · Ellsworth, IABuilt 1966 · S/N D-8214N9587RJetset LLC · Edmonds, WABuilt 1959 · S/N D-6186N9588QNsa LLC · Chandler, AZBuilt 1966 · S/N D-8215N958DMDw Moyer Aviation Inc · Stroudsburg, PABuilt 1982 · S/N CE-1005N958PDrew Jensen Inc · Lincoln, NEBuilt 1978 · S/N TJ-139N958PBMo Elite Air LLC · Rolla, MOBuilt 1981 · S/N TJ-392N9592RHall James H · Discovery Bay, CABuilt 1959 · S/N D-6177N9593RWard David C · Painted Post, NYBuilt 1959 · S/N D-6202N9594QJhb Leasing LLC · Madison, MNBuilt 1966 · S/N TE-178N9596RFournier Louis Wilfred Jr · Lynn Haven, FLBuilt 1959 · S/N D-6190N9597HVeruca Salt LLC · Washington, TXBuilt 1943 · S/N 4840N9597RWise Eric · Enon, OHBuilt 1959 · S/N D-6191N9598QN9598q LLC · Cincinnati, OHBuilt 1966 · S/N D-8222N9598RMcdonald James S · Yorba Linda, CABuilt 1959 · S/N D-6274N9598VTee William K Jr · Carlisle, MABuilt 1966 · S/N D-8115N9598YOber John A · Candor, NYBuilt 1962 · S/N TC-365N9599QDavis Eric · Pisgah Forest, NCBuilt 1966 · S/N D-8221N9599RFry Larry D DBA · Ocala, FLBuilt 1959 · S/N D-6206N959GSSanders Aviation Inc · Jasper, ALS/N TD-596N959QJrobco LLC · Helena, MTS/N D-6838N95AJAvnuts LLC · Pawleys Island, SCBuilt 1978 · S/N E-1254N95BEAmundson David Owen · Sioux Falls, SDBuilt 1964 · S/N TD-590N95BHSale Reported · Lacombe, LASale reported, canceledBuilt 1975 · S/N TJ-29N95CFUes Bluesky Aviation LLC · New Berlin, WIBuilt 1988 · S/N CE-1291N95CJSimmons Marshall · San Antonio, TXBuilt 1960 · S/N TD-334N95CXIsland City Seaplanes Inc · Cordova, AKS/N BA-319N95DBBlankenbeker Edward D · Fernandina Beach, FLBuilt 1979 · S/N D-10239N95DJSanders Aviation Inc · Jasper, ALBuilt 1963 · S/N TD-556N95DLOwen Jayson S · Tampa, FLBuilt 1960 · S/N TD-418N95DPNorthwest Aviation Inc · Oklahoma City, OKBuilt 1978 · S/N TE-1149N95FBSouthern Wings LLC · Shreveport, LABuilt 1964 · S/N TC-640N95FLWolfenden Enterprises Inc · Vero Beach, FLBuilt 1973 · S/N TC-1625N95HJSkyview Aviation LLC · Benton, KYBuilt 1965 · S/N TD-615N95KCTailwinds Flying LLC · Merritt Island, FLS/N TE-203N95KKGrimes Chris · Hudson, NYBuilt 1966 · S/N TD-649N95LSPmx Aviation Services LLC · Kailua Kona, HIBuilt 1963 · S/N TD-533N95PTFinkelstein Robert S · Palm Beach Gardens, FLBuilt 1980 · S/N TC-2346N95RDSwair LLC · Denver, COBuilt 1965 · S/N TC-827N95RRKentucky Oil And Refining Co · Betsy Layne, KYBuilt 1974 · S/N E-541N95VPVarsity Produce Sales Inc · Bakersfield, CABuilt 1980 · S/N EA-114
Back to AD 99-05-13 R1 WD