OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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-01-05-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:99-01-05-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.

N7384KSid R Jensen · Idaho Falls, IDS/N 20-293N7386KAffiliated Equipment Leasing LLC · New Castle, DEBuilt 1950 · S/N 20-295N7387DTodd Doug G · Brainerd, MNBuilt 1957 · S/N 18-5752N7387KBuehler Andrew · Eatonville, WABuilt 1950 · S/N 20-296N7387ZCentral Indiana Soaring Society · Yorktown, INS/N 25-3346N7388DParcel James H · Anchorage, AKS/N 18-5753N7389KBiek Jacob A · Onsted, MIS/N 20-298N7391Christopherson Jack T · Overgaard, AZS/N 20-809N7391DJohnson Robert D Trustee · Anchorage, AKBuilt 1957 · S/N 18-5756N7391KLandry Matthew A · Soldotna, AKS/N 20-300N7393ZDrennan Monte D · Caddo, OKBuilt 1965 · S/N 25-3354N7395KDoty Brandon Charles · Debary, FLS/N 20-304N73AGHarrison Albon Wayne Jr · Lake Jackson, TXBuilt 1951 · S/N 20-622N7400DSmith Dwight S · Ann Arbor, MIBuilt 1957 · S/N 22-5160N7400KLopez Lionel A · Wasilla, AKBuilt 1950 · S/N 20-308N7403KAnderson Jeff · Lewisville, NCBuilt 1950 · S/N 20-311N7404KRegistration Pending · Eagle River, AKRegistration pendingBuilt 1950 · S/N 20-312N7405KPedersen Larry A · Waynesboro, PAS/N 20-314N7408DTobin John C · Olympia, WAS/N 22-5169N7408KCapps Steven · Newcastle, OKBuilt 1950 · S/N 20-317N7409DBartlett Donald R · Weirsdale, FLBuilt 1957 · S/N 22-5170N7409ZFinger Lakes Soaring Club Inc · Dansville, NYFirst renewal noticeBuilt 1965 · S/N 25-3375N740HSSnook Harold F · Beaver Springs, PABuilt 1977 · S/N 18-7709067N7410DHampton Michael D · Marshfield, MOFirst renewal noticeBuilt 1957 · S/N 22-5171N7411DMclain Joseph L · Louisville, KYBuilt 1957 · S/N 22-5172N7412KBailis David P · Bethlehem, PABuilt 1950 · S/N 20-322N7413DDraper Scott · Rutland, VTBuilt 1957 · S/N 22-5174N7413KBecerra Edward Jr · Mount Pleasant, WIBuilt 1950 · S/N 20-323N7414DCulver Robert D · Sacramento, CABuilt 1957 · S/N 22-5175N7417DUnderwood Todd M · Foley, ALBuilt 1957 · S/N 22-5178N7417KHulse Anthony G · Wasilla, AKBuilt 1950 · S/N 20-328N742United States Department Of Agriculture · Cedar City, UTBuilt 1964 · S/N 18-8146N7420KGonzales Kevin F · Alger, OHBuilt 1950 · S/N 20-330N7422DEvans Clyde Joseph · Muscatine, IABuilt 1957 · S/N 22-5183N7422ZFarm Air Inc · Astoria, ILBuilt 1965 · S/N 25-3399N7423KStricker Edwin C · Lucerne Valley, CABuilt 1950 · S/N 20-333N7424DBradley Bane L · Lyndonville, NYBuilt 1957 · S/N 22-5185N7424KSpalding Michael A · Ahoskie, NCBuilt 1950 · S/N 20-334N7426ZKeystone Aviation LLC · Anchorage, AKBuilt 1965 · S/N 18-8308N7429DTomporowski Robert C · Piesco, NYBuilt 1957 · S/N 22-5192N7429KEarley Bruce H · Buckley, WAS/N 20-339N742CGValley Sprayers Inc · Park River, NDBuilt 1978 · S/N 18-7809074N7430ZMayes Brett R · Williams, CABuilt 1965 · S/N 25-3412N7431DWilcox Darrol A · Nenana, AKBuilt 1957 · S/N 22-5190N7432DBlack Delwyn Joe · Irving, TXBuilt 1957 · S/N 22-5195N7433DPierce Stephan L · Graham, TXBuilt 1957 · S/N 22-5197N7433KMills Randall J · Monroe, MIBuilt 1950 · S/N 20-343N7433ZDas Air Inc · Wilmington, DEBuilt 1965 · S/N 25-3416N7435KHickey Aero Services LLC · White Hills, AZS/N 20-344N7435ZShortridge Randall R · Mesa, AZBuilt 1965 · S/N 25-3420
Back to AD 99-01-05 R1