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.

N53AJG Bongard LLC · Fort Myers, FLBuilt 1977 · S/N P-444N53BBWing Bird Aviation LLC · Garland, TXBuilt 1972 · S/N TE-866N53BRLl53 LLC · Naperville, ILBuilt 1953 · S/N G-152N53CBCasper Scott A · Middlebury Center, PABuilt 1954 · S/N D-3822N53CMHeath Larry A · Shawnee, OKBuilt 1953 · S/N D-3448N53DQSwair LLC · Denver, COS/N TC-983N53EMChecker Aircraft LLC · Wilmington, DEBuilt 1976 · S/N MC-395N53GMOnawa Flying Service Inc · Sioux City, IABuilt 1968 · S/N D-8793N53LEBonanza With A Cause LLC · Westlake Village, CAS/N E-3488N53QMWings Enterprizes Ltd Co · Yukon, OKBuilt 1967 · S/N TE-312N53UPSarratt Curtis · Annapolis, MDBuilt 1964 · S/N TC-708N53WSHancock James T · South St Paul, MNBuilt 1967 · S/N TD-706N53WWPlanemarketing LLC · Vero Beach, FLS/N E-3480N53ZZRussell Military Museum · Zion, ILS/N G-279N5400DNablo Dustin · Haddam Neck, CTS/N D-4881N5404DRegistration Pending · Billings, MTRegistration pendingBuilt 1956 · S/N D-4887N5404UHubbard James E · Dover, OHBuilt 1967 · S/N D-8543N5405DKelln David R · Lawton, OKS/N D-4913N5405URyan Good Aviation LLC · Sioux Falls, SDS/N D-8493N5408USanders Aviation Inc · Jasper, ALBuilt 1967 · S/N TD-698N5409DDay William L · Seguin, TXBuilt 1957 · S/N D-4912N5409MJackson David B · Mansfield, TXBuilt 1978 · S/N M-2025N5409UCosco & Associates Inc · Crestview, FLBuilt 1967 · S/N TC-1033N5410UN5410u LLC · West Babylon, NYBuilt 1967 · S/N D-8531N5411DFellows David O · Mc Alpin, FLS/N D-4903N5413USleigh James E · Palm City, FLBuilt 1967 · S/N D-8498N5414DGlobal Flights LLC · Polk City, IABuilt 1957 · S/N D-4921N5416DCook Clay B · Murfreesboro, TNBuilt 1957 · S/N D-4926N5417MGreenhill Daniel J Jr · San Tan Valley, AZBuilt 1978 · S/N M-2022N5418DBriggs Larry E · Oklahoma City, OKBuilt 1957 · S/N D-4917N541DBKing Mark R · Oxnard, CABuilt 1964 · S/N D-7333N5420UJohnson Michele J · Buena Vista, COBuilt 1967 · S/N D-8505N5421DFly First LLC · West Memphis, ARBuilt 1957 · S/N D-4932N5422DJohnson Benjamin Keith · Dayton, OHBuilt 1957 · S/N D-4937N5422URegistration Pending · Livermore, CORegistration pendingBuilt 1967 · S/N TE-407N5425MWong Alex · Hillsborough, CABuilt 1978 · S/N M-2026N5427UPalmer Corliss · Peyton, COBuilt 1967 · S/N TG-12N5428MRegistered aircraftBuilt 1978 · S/N MC-574N5429MAir Systems LLC · San Ramon, CABuilt 1978 · S/N MC-575N542DSFox James R DBA · Saint Paul, MNBuilt 1966 · S/N D-8048N542THoel Erik Gerhard · Redlands, CABuilt 1961 · S/N D-6718N543Onnoh Fred · Oak Harbor, WABuilt 1953 · S/N D-3686N5430DClark Stephen N · Walnut Cove, NCBuilt 1957 · S/N D-4945N5430MAmi Aviation Inc · Monroe, NYBuilt 1978 · S/N MC-573N5431UBrown David G · Knoxville, TNBuilt 1967 · S/N D-8515N5433DWatkins Lawrence A · San Jose, CABuilt 1957 · S/N D-4946N5433UHynes Kevin P · Wichita Falls, TXBuilt 1967 · S/N D-8512N5434UVance Daniel · Bend, ORBuilt 1967 · S/N D-8520N5435DGoheen Robert Grant · Saint Petersburg, FLBuilt 1957 · S/N D-4944N5436DSeitz Aviation LLC · Hayden, IDBuilt 1957 · S/N D-4964
Back to AD 99-05-13 R1 WD