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.

N203PLHhj & Rbj Holdings LLC · Prattville, ALBuilt 1976 · S/N D-9898N203RTKinzer Richard J · Piney Flats, TNBuilt 1962 · S/N D-6931N2040ASchultz Philip W · Lancaster, CABuilt 1969 · S/N D-9024N2040CWatson Anthony A · Midlothian, TXBuilt 1977 · S/N E-1135N2040GFinal Forge LLC · Blountville, TNBuilt 1978 · S/N E-1380N2040PTrb Aviation LLC · Fredericksburg, VABuilt 1978 · S/N D-10183N2040UGillim Parvin D · Sheridan, INBuilt 1978 · S/N E-1381N2040YCappel Eric H · Satellite Beach, FLBuilt 1978 · S/N D-10181N2041DLyman Eric J · Upland, CABuilt 1952 · S/N D-3393N2041LSlik Air LLC · Topeka, KSBuilt 1976 · S/N M-1849N2041PManke Brian W · Chesapeake, VABuilt 1978 · S/N CE-821N2041WJimenez John D · San Antonio, TXS/N D-7982N2041ZBlue Mesa LLC · Bend, ORBuilt 1978 · S/N TE-1144N2042BHasemann James M · Gaithersburg, MDBuilt 1978 · S/N D-10185N2042ESmith James E Trustee · Kalispell, MTS/N TC-2188N2042YPierson Daniel D · Kalispell, MTS/N G-826N2043GBreaking Wind LLC · Alabaster, ALBuilt 1978 · S/N TC-2189N2043LBrown Dennis · Moncks Corner, SCBuilt 1976 · S/N M-1856N2043XWright Air Service Inc · Fairbanks, AKBuilt 1978 · S/N E-1387N20444Cesafsky Allen A · Bend, ORBuilt 1978 · S/N CE-824N2044ABrowder Daniel Klemp · Shady Valley, TNBuilt 1979 · S/N TJ-190N2044KSchutze Curt · Knoxville, TNBuilt 1978 · S/N E-1389N2044LLeitner Jay T · Hurst, TXBuilt 1976 · S/N MC-440N2044PSnoe Gary A · Somerville, TXS/N TC-2178N2044VPerformance Construction LLC · Paris, TXBuilt 1978 · S/N E-1390N2044WMccraw Richard L Trustee · Hinesburg, VTBuilt 1978 · S/N E-1391N2045CBarreto Antonio Trustee · Norco, CABuilt 1978 · S/N E-1392N2045EDouble P Investments LLC · Kerrville, TXBuilt 1978 · S/N E-1393N2046LRegistration Pending · Bonham, TXRegistration pendingBuilt 1976 · S/N MC-433N2046WKj Cessna LLC · Waxahachie, TXBuilt 1978 · S/N CE-825N2046YBrainerd William F III · Sapello, NMBuilt 1978 · S/N E-1395N2046ZFreedom Flying Club LLC · Fort Collins, COBuilt 1978 · S/N E-1396N20478V35b Bonanza LLC · Temecula, CAS/N D-10194N2047ABig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-899N2047BField Inspection LLC · Brawley, CABuilt 1978 · S/N E-1394N2047NAwa Aviation LLC · Sacramento, CABuilt 1978 · S/N E-1400N2047PFromknecht Robert L · Quakertown, PABuilt 1978 · S/N E-1401N2047WKapusta Marian · Clearwater, FLBuilt 1965 · S/N D-7986N2048ABig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-904N2048BCicciari David A · Cincinnati, OHBuilt 1978 · S/N E-1402N2048LDp Network LLC · Coconut Creek, FLBuilt 1976 · S/N M-1857N2048V5l Aviation LLC · Decatur, TXBuilt 1978 · S/N E-1404N2048WTripi Mark DBA · Parkersburg, WVBuilt 1965 · S/N D-7987N2048ZJulis Wings LLC · Jacksonville, FLBuilt 1978 · S/N CE-828N2049ASouth Delta Aviation Inc · West Helena, ARBuilt 1978 · S/N E-1405N2049NAdvanced Aviation LLC · New Century, KSBuilt 1978 · S/N D-10190N2049WHufford P Thomas Trustee · San Diego, CABuilt 1965 · S/N D-7985N2049ZObie Edgar L · Chinook, MTBuilt 1978 · S/N E-1398N204BTulin Bradley G · Sedona, AZBuilt 1956 · S/N D-4548N204LPSteffenhagen Julian L Jr Trustee · Tustin, CABuilt 1988 · S/N CE-1262
Back to AD 99-05-13 R1 WD